Artifact 302b34f77faf7ee5a95c45e5ad960f0d11247240595563f1dd05a0f63a01d710:

Ticket change [302b34f77f] - New ticket [7f39060a24b47353|7f39060a24] <i>LEFT JOIN malfunctions with partial ISNULL index</i>. by mrigger 2019-11-30 17:51:24.

---

D 2019-11-30T17:51:24.953
J foundin 3.30.0
J icomment Consider\sthe\sfollowing\stest\scase:\r\n\r\n<pre>\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</pre>\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<pre>\r\nSELECT\st0.c0\sISNULL\sFROM\st1\sLEFT\sJOIN\st0;\s--\s0\r\n</pre>
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