Message80849
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'] |
|
Date |
User |
Action |
Args |
2009-01-31 02:22:13 | ggenellina | set | recipients:
+ ggenellina, sockonafish |
2009-01-31 02:22:13 | ggenellina | set | messageid: <1233368533.19.0.525370982526.issue5105@psf.upfronthosting.co.za> |
2009-01-31 02:22:11 | ggenellina | link | issue5105 messages |
2009-01-31 02:22:10 | ggenellina | create | |
|