[Bug 1021044] Re: sqlite 3.7.9 is old and has bug which means it incorrectly processes sql

[Sebastien Bacher]

The commit to fix it seems to be
http://www.sqlite.org/src/vpatch?from=efee39e64bd95c28&to=0dc4cb935514131c

if somebody wants to have a look at backporting it

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to sqlite3 in Ubuntu.
https://bugs.launchpad.net/bugs/1021044

Title:
  sqlite 3.7.9 is old and has bug which means it incorrectly processes
  sql

Status in “sqlite3” package in Ubuntu:
  Fix Released
Status in “sqlite3” source package in Precise:
  Triaged

Bug description:
  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).

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/1021044/+subscriptions