SQLite
Artifact Content
Not logged in

Artifact 28fef2d3485dc464d5421ee48c8874d25bb281cf:

Ticket change [28fef2d348] - New ticket [d02e1406a58ea02de21627afaea1a5acd3a2e673|d02e1406a5] LEFT JOIN with an OR in the ON clause causes segfault. by drh 2012-10-04 15:26:42.
D 2012-10-04T15:26:42.243
J comment The\sfollowing\sSQL\sresults\sin\sa\ssegfault\swhile\srunning\sthe\sSELECT\sstatement.\r\n\r\n<blockquote><pre>\r\nCREATE\sTABLE\st1(a,b,c);\r\nINSERT\sINTO\st1\sVALUES(1,2,3),\s(4,5,6);\r\nCREATE\sTABLE\st2(d,e,f);\r\nINSERT\sINTO\st2\sVALUES(3,6,9),\s(4,8,12);\r\nSELECT\s*\sFROM\st1\sAS\sx\sLEFT\sJOIN\st2\sAS\sy\sON\s(y.d=x.c)\sOR\s(y.e=x.b);\r\n</blockquote></pre>\r\n\r\nThis\sproblem\swas\sinitially\sreported\son\sthe\s[http://www.mail-archive.com/sqlite-users%40sqlite.org/msg72899.html\s|\smailing\slist].\s\sThe\sproblem\s\r\nappears\sto\shave\sbeen\sintroduced\sby\scheck-in\s[62678be3df35cdcb091]\sand\sfirst\r\nappeared\sin\sversion\s3.7.14.
J detected Application_Fault
J foundin 3.7.14
J severity Critical
J status Open
J subsystem Unknown
J title LEFT\sJOIN\swith\san\sOR\sin\sthe\sON\sclause\scauses\ssegfault
J type Code_Defect
K d02e1406a58ea02de21627afaea1a5acd3a2e673
U drh
Z 572218258503a5cc44569d7b15c25e4f