summaryrefslogtreecommitdiff
path: root/test/sql/query.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/query.py')
-rw-r--r--test/sql/query.py5
1 files changed, 5 insertions, 0 deletions
diff --git a/test/sql/query.py b/test/sql/query.py
index 7790b5f34..fa88c5fe6 100644
--- a/test/sql/query.py
+++ b/test/sql/query.py
@@ -361,6 +361,11 @@ class QueryTest(PersistTest):
"UNION select query_users.user_id, query_users.user_name from query_users", bind=testbase.db).execute().fetchone()
self.assert_(r['user_id']) == 1
self.assert_(r['user_name']) == "john"
+
+ # test using literal tablename.colname
+ r = text('select query_users.user_id AS "query_users.user_id", query_users.user_name AS "query_users.user_name" from query_users', bind=testbase.db).execute().fetchone()
+ self.assert_(r['query_users.user_id']) == 1
+ self.assert_(r['query_users.user_name']) == "john"
def test_ambiguous_column(self):