D 2013-05-09T13:38:23.218
J foundin 3.7.16.2
J icomment The\sfollowing\sSQL\soutputs\sa\ssingle\srow\swhen\sit\sshould\soutput\szero\srows:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(x);\sINSERT\sINTO\st1\sVALUES(1);\r\nCREATE\sTABLE\st2(y\sINTEGER\sPRIMARY\sKEY,a,b);\r\nINSERT\sINTO\st2\sVALUES(1,2,3);\r\nSELECT\s*\sFROM\st1\sLEFT\sJOIN\st2\sON\sa=2\sOR\sb=3\sWHERE\sy\sIS\sNULL;\r\n</verbatim></blockquote>\r\n\r\nThe\sresult\sof\sthe\sabove\sis\s"1,NULL,NULL,NULL".\s\sIt\sis\sbehaving\r\nas\sif\sthe\s"y\sIS\sNULL"\sterm\sof\sthe\sWHERE\sclause\shas\sbeen\smoved\sinside\s\r\nthe\sON\sclause\sof\sthe\sLEFT\sJOIN.\s\sThis\seffect\sis\sonly\sseen\swhen\sthere\r\nis\san\sOR\soperator\sinside\sthe\sON\sclause.\r\n\r\nBisecting\sreveals\sthat\sthis\sproblem\r\nwas\sintroduced\sby\son\s2011-10-07\sby\scheck-in\s[b23ae131874bc5c6]\sand\r\nfirst\sappeared\sin\srelease\s3.7.9.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Incorrect\sresults\swhen\sOR\sis\sused\sin\sthe\sON\sclause\sof\sa\sLEFT\sJOIN
J type Code_Defect
K f2369304e47167e3e644e2f1fe9736063391d7b7
U drh
Z 6aa48d86ad4f5184b883500ac3630651