/ Ticket Change Details
Login
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

  1. Change icomment to:

    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.

  2. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change severity to "Minor"
  5. Change status to "Open"
  6. Change title to:

    Incorrect query result when redundant terms appears in WHERE clause

  7. Change type to "Code_Defect"