added a test to validate ResultProxy truncation behavior

1 files changed, 7 insertions, 0 deletions

diff --git a/test/sql/query.py b/test/sql/query.py
index 21a087628..7790b5f34 100644
--- a/test/sql/query.py
+++ b/test/sql/query.py
@@ -355,6 +355,13 @@ class QueryTest(PersistTest):
         self.assert_(r[0:1] == (1,))
         self.assert_(r[1:] == (2, 'foo@bar.com'))
         self.assert_(r[:-1] == (1, 2))
+        
+        # test a little sqlite weirdness - with the UNION, cols come back as "query_users.user_id" in cursor.description
+        r = text("select query_users.user_id, query_users.user_name from query_users "
+            "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"
+        
 
     def test_ambiguous_column(self):
         users.insert().execute(user_id=1, user_name='john')