From 65abc780104f38b8610e6d368d2a5b655ce1f264 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 27 Nov 2007 16:13:45 +0000 Subject: [PATCH] added a test to validate ResultProxy truncation behavior --- test/sql/query.py | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/test/sql/query.py b/test/sql/query.py index 21a0876282..7790b5f34a 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') -- 2.47.3