- reinstate insert returning back into test_insert.py; defaultdialect

needs to be explicit here since tablestest sticks testing.db onto metadata.bind

1 files changed, 10 insertions, 0 deletions

diff --git a/test/sql/test_insert.py b/test/sql/test_insert.py
index c74e11e18..cd040538f 100644
--- a/test/sql/test_insert.py
+++ b/test/sql/test_insert.py
@@ -109,6 +109,16 @@ class InsertTest(_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL):
         self.assert_compile(table.insert(inline=True),
             'INSERT INTO sometable (foo) VALUES (foobar())', params={})
 
+    def test_insert_returning_not_in_default(self):
+        table1 = self.tables.mytable
+
+        stmt = table1.insert().returning(table1.c.myid)
+        assert_raises_message(
+            exc.CompileError,
+            "RETURNING is not supported by this dialect's statement compiler.",
+            stmt.compile,
+            dialect=default.DefaultDialect()
+        )
 
 class EmptyTest(_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL):
     __dialect__ = 'default'