SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: 28fef2d3485dc464d5421ee48c8874d25bb281cf
Ticket: d02e1406a58ea02de21627afaea1a5acd3a2e673
LEFT JOIN with an OR in the ON clause causes segfault
Date: 2012-10-04 15:26:42
User: drh
Changes

  1. Change comment to:

    The following SQL results in a segfault while running the SELECT statement.

    CREATE TABLE t1(a,b,c);
    INSERT INTO t1 VALUES(1,2,3), (4,5,6);
    CREATE TABLE t2(d,e,f);
    INSERT INTO t2 VALUES(3,6,9), (4,8,12);
    SELECT * FROM t1 AS x LEFT JOIN t2 AS y ON (y.d=x.c) OR (y.e=x.b);
    

    This problem was initially reported on the mailing list. The problem appears to have been introduced by check-in 62678be3df35cdcb091 and first appeared in version 3.7.14.

  2. Change detected to "Application_Fault"
  3. Change foundin to "3.7.14"
  4. Change severity to "Critical"
  5. Change status to "Open"
  6. Change subsystem to "Unknown"
  7. Change title to:

    LEFT JOIN with an OR in the ON clause causes segfault

  8. Change type to "Code_Defect"