[Bug 296390] Re: Packaged version of SQLite (3.5.9) returns incorrect results from SELECT DISTINCT query

[Bug Watch Updater]

** Changed in: debian
       Status: Unknown => Fix Released

-- 
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/296390

Title:
  Packaged version of SQLite (3.5.9) returns incorrect results from
  SELECT DISTINCT query

Status in Divmod Imaginary:
  Invalid
Status in txcomputegrid - twisted based compute grid:
  Invalid
Status in “sqlite3” package in Ubuntu:
  Fix Released
Status in Debian GNU/Linux:
  Fix Released

Bug description:
  exarkun at takkun:~$ cat /etc/lsb-release 
  DISTRIB_ID=Ubuntu
  DISTRIB_RELEASE=8.10
  DISTRIB_CODENAME=intrepid
  DISTRIB_DESCRIPTION="Ubuntu 8.10"
  exarkun at takkun:~$ sqlite3
  SQLite version 3.5.9
  Enter ".help" for instructions
  sqlite> CREATE TABLE foo(foo TEXT);
  sqlite> INSERT INTO foo VALUES ('a');
  sqlite> INSERT INTO foo VALUES ('b');
  sqlite> CREATE INDEX foo_foo ON foo(foo);
  sqlite> SELECT DISTINCT foo FROM foo WHERE foo IS NOT NULL;
  b
  sqlite> 

  The correct result would have been the rows for a and b, not just b.
  This bug is apparently fixed in a later release of SQLite.

To manage notifications about this bug go to:
https://bugs.launchpad.net/imaginary/+bug/296390/+subscriptions