[Bug 1089478] Re: SELECT DISTINCT returns incorrect results

[DavidM]

is there still a maintainer for this package ? we really need an update,
thx

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

Title:
  SELECT DISTINCT returns incorrect results

Status in “sqlite3” package in Ubuntu:
  Confirmed

Bug description:
  We are moving to precise andI have a user that reports:

  % sqlite3 /scratch/cluster/cdunham/437.leslie3d/4/simpoint/trace.db
  SELECT b FROM
  (SELECT DISTINCT(b) AS b FROM cfg WHERE a IN(SELECT a FROM cfg
             GROUP BY a HAVING COUNT(b) > 1))
  WHERE b=1232;

  This query should return one row because of the DISTINCT() in the inner
  query, but on the angrist-* (Precise) machines, it returns two.

  The version of SQLite on these machines is 3.7.9, and the bug is also
  present in 3.7.10.  The bug was fixed in SQLite 3.7.11 (March 2012), and the
  latest SQLite is 3.7.14.1.

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