Overview
Artifact ID: | 28fef2d3485dc464d5421ee48c8874d25bb281cf |
---|---|
Ticket: | d02e1406a58ea02de21627afaea1a5acd3a2e673
LEFT JOIN with an OR in the ON clause causes segfault |
User & Date: | drh 2012-10-04 15:26:42 |
Changes
- comment changed 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.
- Untracked field detected: "Application_Fault"
- foundin changed to: "3.7.14"
- severity changed to: "Critical"
- status changed to: "Open"
- subsystem changed to: "Unknown"
- title changed to:
LEFT JOIN with an OR in the ON clause causes segfault
- type changed to: "Code_Defect"