Gabriel Genellina <gagsl-...@yahoo.com.ar> added the comment: See http://www.sqlite.org/cvstrac/tktview?tn=3221
Try upgrading to the latest sqlite release. Or set "pragma full_column_names=ON;" import sqlite3 conn = sqlite3.connect(':memory:') cursor = conn.cursor() cursor.execute("create table T (a, b, c)") cursor.execute("insert into T values (1, 2, 3)") cursor.execute("insert into T values (2, 3, 4)") conn.commit() cursor.execute("pragma short_column_names=OFF;") cursor.execute("pragma full_column_names=ON;") cursor.execute("select * from T T1, T T2 where T1.a=T2.b") print [d[0] for d in cursor.description] # output: ['T1.a', 'T1.b', 'T1.c', 'T2.a', 'T2.b', 'T2.c'] _______________________________________ Python tracker <rep...@bugs.python.org> <http://bugs.python.org/issue5105> _______________________________________ _______________________________________________ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com