/ View Ticket
Login
Ticket UUID: 1dcb4d44964846ad56e8cc74655f1d61d6e7f59b
Title: Incorrect query result when redundant terms appears in WHERE clause
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-02-13 22:12:55
Version Found In:
User Comments:
drh added on 2020-02-13 20:37:37:

The following SQL generates an extra, incorrect result row:

CREATE TABLE t1(x TEXT);
CREATE TABLE t2(y TEXT);
INSERT INTO t1 VALUES('good'),('bad');
INSERT INTO t2 VALUES('good'),('bad');
SELECT * FROM t1 JOIN t2 ON x=y
 WHERE x='good' AND y='good';

This problem was reported on the mailing list by Jim Bosch. Bisecting shows that the malfunction was introduced by check-in [1c3e5c20a9e6f501] on 2020-01-08. That check-in appears in versions 3.31.0 and 3.31.1.