SQLite
View Ticket
Not logged in
Ticket UUID: 61fe97454c00bc4a5f5d826af02161d7df0a40c0
Title: Duplicate result using an IN operator in the WHERE clause
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2017-04-24 14:57:43
Version Found In: 3.18.0
User Comments:
drh added on 2017-04-24 13:49:14:

The following SQL results in three rows of output instead of just two:

CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT);
INSERT INTO t1(b) VALUES ('one'), ('two');
SELECT a FROM t1 WHERE a IN (1,2,1,2);

This bug was originally reported on the System.Data.SQLite mailing list. Bisect traces the problem back to check-in [925840cfdb] so that the problem was introduced in release 3.16.0.


dan added on 2017-04-24 14:57:43:

Fixed by [1c1b0862] .