| Ticket Hash: | 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:
(text/x-fossil-wiki)
The following SQL results in three rows of output instead of just two:
<blockquote><verbatim>
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);
</verbatim></blockquote>
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: (text/x-fossil-wiki) Fixed by [1c1b0862] . | ||||