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.
    
    <blockquote><pre>
    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);
    </blockquote></pre>
    
    This problem was initially reported on the [http://www.mail-archive.com/sqlite-users%40sqlite.org/msg72899.html | 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"