diff options
Diffstat (limited to 'test/sql/test_query.py')
| -rw-r--r-- | test/sql/test_query.py | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/test/sql/test_query.py b/test/sql/test_query.py index a475b899f..2075bcecf 100644 --- a/test/sql/test_query.py +++ b/test/sql/test_query.py @@ -276,6 +276,13 @@ class QueryTest(fixtures.TestBase): r = t6.insert().values(manual_id=id).execute() eq_(r.inserted_primary_key, [12, 1]) + def test_implicit_id_insert_select(self): + stmt = users.insert().from_select( + (users.c.user_id, users.c.user_name), + users.select().where(users.c.user_id == 20)) + + testing.db.execute(stmt) + def test_row_iteration(self): users.insert().execute( {'user_id': 7, 'user_name': 'jack'}, |