Artifact
bac716244fddac1fe8417c1dd1c9fa6e2b91ab028d3981e8c69fbe70e3de95aa:
Ticket change
[bac71624]
- New ticket
[f8f472cb] Partial index and BETWEEN issue.
by
mrigger
2019-08-30 15:43:35.
D 2019-08-30T15:43:35.387
J foundin 3.29.0
J icomment In\sthe\sexample\sbelow,\san\sINDEX\scauses\sa\squery\sto\smalfunction:\r\n\r\n<pre>\r\nCREATE\sTABLE\st0\s(c0);\r\nCREATE\sINDEX\si0\sON\st0(1)\sWHERE\sc0\sNOT\sNULL;\r\nINSERT\sINTO\st0(c0)\sVALUES\s(NULL);\r\nSELECT\s*\sFROM\st0\sWHERE\s''\sBETWEEN\st0.c0\sAND\s1\sIN\s(FALSE);\s--\sunexpected:\srow\sis\snot\sfetched\r\n</pre>\r\n\r\nThe\sexpression\sshould\sevaluate\sto\sTRUE:\r\n\r\n<pre>\r\nSELECT\s''\sBETWEEN\st0.c0\sAND\s1\sIN\s(FALSE)\sFROM\st0;\s--\sTRUE\r\n</pre>
J login mrigger
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Partial\sindex\sand\sBETWEEN\sissue
J type Code_Defect
K f8f472cbc77ba9c9251feb1d2b6674e1e0587e0e
U mrigger
Z 98dfe993eb0cb2d4b8d81073f0b67fb2