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

[Sebastien Bacher]

** Description changed:

+ Impact:
+ Some sql commands can return wrong values
+ 
+ Test Case:
+ - run sqlite3
+ - copy those commands
+ 
+ "CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, d);
+ CREATE TABLE t2(x INTEGER PRIMARY KEY, y);
+ CREATE TABLE t3(p INTEGER PRIMARY KEY, q);
+ INSERT INTO t1 VALUES(2,3,4,5);
+ INSERT INTO t1 VALUES(3,4,5,6);
+ INSERT INTO t2 VALUES(2,4);
+ INSERT INTO t3 VALUES(5,55);
+ 
+ SELECT * FROM t1 LEFT JOIN t2 ON y=b JOIN t3 WHERE c==p OR d==p;"
+ 
+ - the result should be 2 rows, only one is displayed on precise before
+ the SRU
+ 
+ Regression Testing:
+ sqlite is used in quite some place, check that applications running it still work correctly
+ 
+ ---
+ 
  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).

-- 
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:
  In Progress

Bug description:
  Impact:
  Some sql commands can return wrong values

  Test Case:
  - run sqlite3
  - copy those commands

  "CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, d);
  CREATE TABLE t2(x INTEGER PRIMARY KEY, y);
  CREATE TABLE t3(p INTEGER PRIMARY KEY, q);
  INSERT INTO t1 VALUES(2,3,4,5);
  INSERT INTO t1 VALUES(3,4,5,6);
  INSERT INTO t2 VALUES(2,4);
  INSERT INTO t3 VALUES(5,55);

  SELECT * FROM t1 LEFT JOIN t2 ON y=b JOIN t3 WHERE c==p OR d==p;"

  - the result should be 2 rows, only one is displayed on precise before
  the SRU

  Regression Testing:
  sqlite is used in quite some place, check that applications running it still work correctly

  ---

  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