Package: libsqlite3-0 Version: 3.7.15-1 When using sub queries I can no longer make use of the rowid. With the version shipped in testing (3.7.13-1) it works as expected.
A small example: sqlite3 test.db sqlite> create table test (line varchar); sqlite> insert into test (line) values ("a"); sqlite> insert into test (line) values ("b"); sqlite> insert into test (line) values ("c"); sqlite> insert into test (line) values ("d"); sqlite> select rowid from (select * from test limit 0, -1) where line="c"; With 3.7.15-1 this returns an empty line while 3.7.13-1 returns '3' as expected. Since this also doesn't work in C code using the library I filed this against libsqlite3-0 and not sqlite3. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org