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