SELECT DISTINCT returns incorrect results
Bug #1089478 reported by
KayNettle
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
sqlite3 (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
We are moving to precise andI have a user that reports:
% sqlite3 /scratch/
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 post a comment you must log in.
Status changed to 'Confirmed' because the bug affects multiple users.