[Bug 1089478] [NEW] SELECT DISTINCT returns incorrect results

[KayNettle]

Public bug reported:

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.

** Affects: sqlite3 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
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:
  New

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