Public bug reported: I have just installed ubuntu-server 12.04 after a hardware crash replacing a Debian squeeze server. One of my applications uses fairly complex SQL with sqlite3.
Back in March this year, I was finding a discontinuity between the results of my application running on the Debian server using sqlite 3.7.3 and by Debian Unstable Desktop, which at that time was running sqlite 3.7.10. This is reported at http://www.sqlite.org/src/info/b7c8682cc1 I have just discovered that this bug (the ticket reported above gives a test case) does in fact manifest itself in sqlite 3.7.9 This is now causing me the same problems (ie the application silently gives the wrong results) as it did before. Given that I suspect this issue could silently cause other people problems, I believe the version in use in 12.04 needs to be updated to a later release (at least 3.7.11 where the issue is fixed). Obviously this doesn't just affect the sqlite3 package itself, but all the other related packages (in my case php5-sqlite). ** Affects: sqlite3 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1021044 Title: sqlite 3.7.9 is old and has bug which means it incorrectly processes sql To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/1021044/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs