diff options
Diffstat (limited to 'test/dialect/test_sqlite.py')
-rw-r--r-- | test/dialect/test_sqlite.py | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index cfc49af12..3f714b825 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -346,7 +346,7 @@ class DefaultsTest(fixtures.TestBase, AssertsCompiledSQL): @testing.provide_metadata def test_boolean_default(self): - t= Table("t", self.metadata, + t = Table("t", self.metadata, Column("x", Boolean, server_default=sql.false())) t.create(testing.db) testing.db.execute(t.insert()) @@ -356,6 +356,19 @@ class DefaultsTest(fixtures.TestBase, AssertsCompiledSQL): [(False,), (True,)] ) + def test_old_style_default(self): + """test non-quoted integer value on older sqlite pragma""" + + dialect = sqlite.dialect() + eq_( + dialect._get_column_info("foo", "INTEGER", False, 3, False), + {'primary_key': False, 'nullable': False, + 'default': '3', 'autoincrement': False, + 'type': INTEGER, 'name': 'foo'} + ) + + + class DialectTest(fixtures.TestBase, AssertsExecutionResults): |