SELECT DISTINCT returns incorrect results

[KayNettle]

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.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[DavidM (david-maciejak)]

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