/ 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. 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.
    
  2. login: "drh"
  3. mimetype: "text/x-fossil-wiki"
  4. severity changed to: "Minor"
  5. status changed to: "Open"
  6. title changed to:
    Incorrect query result when redundant terms appears in WHERE clause
    
  7. type changed to: "Code_Defect"