Re: [sqlite] Behavior change: INTEGER PRIMARY KEY and PRAGMA index_list

2014-10-06 Thread Paul Quinn
: [sqlite] Behavior change: INTEGER PRIMARY KEY and PRAGMA index_list Paul Quinn wrote: > In 3.7, issuing "PRAGMA index_list(tablename)" to retrieve the details > of an index, sqlite3_column_count() would return 0 for automatic > integer primary key indexes, basically indi

Re: [sqlite] Behavior change: INTEGER PRIMARY KEY and PRAGMA index_list

2014-10-05 Thread Clemens Ladisch
Paul Quinn wrote: > In 3.7, issuing "PRAGMA index_list(tablename)" to retrieve the details > of an index, sqlite3_column_count() would return 0 for automatic > integer primary key indexes, basically indicating there was no > explicit index created for that tablename. But in 3.8, > sqlite3_column_co

[sqlite] Behavior change: INTEGER PRIMARY KEY and PRAGMA index_list

2014-10-01 Thread Paul Quinn
Our existing implementation is failing due to inconsistency between SQLite 3.7.17 and current 3.8.6. Might have existed in earlier 3.8, but we're just upgrading now. In 3.7, issuing "PRAGMA index_list(tablename)" to retrieve the details of an index, sqlite3_column_count() would return 0 for aut