summaryrefslogtreecommitdiff
path: root/test/dialect/test_sqlite.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/dialect/test_sqlite.py')
-rw-r--r--test/dialect/test_sqlite.py15
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):