summaryrefslogtreecommitdiff
path: root/test/sql/query.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-11-27 16:57:56 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-11-27 16:57:56 +0000
commit3f6e94e8185591bd5a32f3558bb5419e0df01763 (patch)
tree68d88e8fdab2c497d293d5df616c82ca56c4c939 /test/sql/query.py
parent6ed4645f02f6cff6bfb46c2eb93004d378a9f423 (diff)
downloadsqlalchemy-3f6e94e8185591bd5a32f3558bb5419e0df01763.tar.gz
- column labels in the form "tablename.columname", i.e. with a dot, are now
supported.
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):