SQLite: View Ticket

Ticket Hash:	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 5.38 years ago	Created:	2020-02-13 20:37:37 5.38 years ago
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.