/ View Ticket
Login
2017-06-17
00:39
When building an ephemeral table of integers, do not assume that the table does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. Also increase the version number to 3.18.2. This is the release candidate. (check-in: e1b71029 user: drh tags: branch-3.18)
2017-04-24
14:57 Closed ticket [61fe9745]: Duplicate result using an IN operator in the WHERE clause plus 6 other changes (artifact: 3998d56c user: dan)
14:16
When building an ephemeral table of integers, do not assume that the table does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. (check-in: 1c1b0862 user: dan tags: trunk)
13:49 New ticket [61fe9745] Duplicate result using an IN operator in the WHERE clause. (artifact: dde67a53 user: drh)

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] .