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

Reply via email to