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
