[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
** Changed in: debian Status: Unknown = Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/296390 Title: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query To manage notifications about this bug go to: https://bugs.launchpad.net/imaginary/+bug/296390/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
Hey Rolf, I just tried the package in your PPA and the problem does appear to be fixed. The example in my first comment now produces two rows of results, a and b, instead of just one. Thanks! -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
Invalididating tasks for txcomputergrid and divmod, then ** Changed in: txcomputegrid Status: New = Invalid -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
version in Jaunty already includes upstream fix. Closing for Jaunty, Intrepid task still open and being worked on. ** Changed in: imaginary Status: New = Invalid ** Changed in: sqlite3 (Ubuntu) Status: Confirmed = Fix Released -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
Please take a look at the the latest sqlite3 and libsqlite3 packages from my PPA. -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
Hi Rolf, thank you very much for looking at this issue. I installed both sqlite3 and libsqlite3 from your PPA, and as JP pointed out, it seems that the bug still exists - the SQL interaction gives exactly the same result. ** Changed in: sqlite3 (Ubuntu) Status: New = Confirmed -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
I would like to help resolve this issue. The upstream bug report is http://www.sqlite.org/cvstrac/tktview?tn=3236. The patch to fix the bug is http://www.sqlite.org/cvstrac/patchset?cn=5341. What else can I do? -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
Can those affected by this bug please try installing sqlite3 and libsqlite3 from my PPA (https://launchpad.net/~r0lf/+archive) and report if that fixes the problem? In that case, we'd see a duplicate of bug 254228 where you can read more about the background. ** Changed in: sqlite3 (Ubuntu) Status: New = Incomplete -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
I still seem to be able to reproduce this problem. I installed libsqlite3-0_3.5.9-3ubuntu1_i386.deb and then re-ran the above SQLite interaction with the same outcome. ** Changed in: sqlite3 (Ubuntu) Status: Incomplete = New -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
** Also affects: txcomputegrid Importance: Undecided Status: New -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
The upstream bug report seems to be http://www.sqlite.org/cvstrac/tktview?tn=3236. It is marked as a duplicate of another ticket which doesn't seem as related, but I'm sure the SQLite contributor who marked it as such is more familiar with the codebase than I. In any case, applying the diff in the revision linked from that ticket to the 3.5.9 source results in a SQLite which does not exhibit this particular bug. -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
This is Debian bug #500792, but I have idea how to indicate that in Launchpad. -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query
** Bug watch added: Debian Bug tracker #500792 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=500792 ** Also affects: debian via http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=500792 Importance: Unknown Status: Unknown -- Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query https://bugs.launchpad.net/bugs/296390 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs