Overview
Artifact ID: | 2274c85b7a4eeb2a510faef879db2d55fbe207854951fe7ef9e548c8af9f1ae1 |
---|---|
Ticket: | 1dcb4d44964846ad56e8cc74655f1d61d6e7f59b
Incorrect query result when redundant terms appears in WHERE clause |
User & Date: | drh 2020-02-13 20:37:37 |
Changes
- icomment:
The following SQL generates an extra, incorrect result row: <blockquote><verbatim> 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'; </verbatim></blockquote> 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.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Minor"
- status changed to: "Open"
- title changed to:
Incorrect query result when redundant terms appears in WHERE clause
- type changed to: "Code_Defect"