summaryrefslogtreecommitdiff
path: root/test/sql/test_insert.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_insert.py')
-rw-r--r--test/sql/test_insert.py17
1 files changed, 17 insertions, 0 deletions
diff --git a/test/sql/test_insert.py b/test/sql/test_insert.py
index 79de40e9c..2fa1860de 100644
--- a/test/sql/test_insert.py
+++ b/test/sql/test_insert.py
@@ -598,6 +598,23 @@ class InsertTest(_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL):
dialect=d
)
+ def test_anticipate_no_pk_lower_case_table(self):
+ t = table(
+ 't',
+ Column(
+ 'id', Integer, primary_key=True, autoincrement=False),
+ Column('notpk', String(10), nullable=True)
+ )
+ with expect_warnings(
+ "Column 't.id' is marked as a member.*"
+ "may not store NULL.$"
+ ):
+ self.assert_compile(
+ t.insert(),
+ "INSERT INTO t () VALUES ()",
+ params={}
+ )
+
class InsertImplicitReturningTest(
_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL):