D 2019-11-30T17:51:24.953 J foundin 3.30.0 J icomment Consider\sthe\sfollowing\stest\scase:\r\n\r\n
\r\nCREATE\sTABLE\st0(c0);\r\nCREATE\sTABLE\st1(c0);\r\nCREATE\sINDEX\si0\sON\st0(1)\sWHERE\sc0\sISNULL;\r\nINSERT\sINTO\st0(c0)\sVALUES\s(1);\r\nINSERT\sINTO\st1(c0)\sVALUES\s(1);\r\nSELECT\s*\sFROM\st1\sLEFT\sJOIN\st0\sWHERE\st0.c0\sISNULL;\s--\sunexpected:\srow\sis\sfetched\r\n
\r\n\r\nUnexpectedly,\sa\srow\sis\sfetched.\sIt\sis\snot\sfetched\swhen\sthe\sindex\sis\somitted\sand\sthe\sfollowing\sstatement\sindicates\sthat\st0.c0\sISNULL\sshould\sevaluate\sto\sfalse:\r\n\r\n
\r\nSELECT\st0.c0\sISNULL\sFROM\st1\sLEFT\sJOIN\st0;\s--\s0\r\n
J login mrigger J mimetype text/x-fossil-wiki J severity Critical J status Open J title LEFT\sJOIN\smalfunctions\swith\spartial\sISNULL\sindex J type Code_Defect K 7f39060a24b47353b9343db9c214e3727f8c698b U mrigger Z ab044da69e1c6dbf87225bf7ae881622