D 2018-12-08T13:06:23.553
J foundin 3.26.0
J icomment The\sfollowing\sscript\sreturns\sno\srows\sbefore\sthe\spartial\sindex\sis\screated,\r\nand\sone\srow\safterwards.\s\sThe\scorrect\sanswer\sis\sno\srows:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a,b);\r\nINSERT\sINTO\st1\sVALUES(1,1);\r\nINSERT\sINTO\st1\sVALUES(2,2);\r\nCREATE\sTABLE\st2(x);\r\nINSERT\sINTO\st2\sVALUES(1);\r\nINSERT\sINTO\st2\sVALUES(2);\r\nSELECT\s'one',\s*\sFROM\st2\sWHERE\sx\sNOT\sIN\s(SELECT\sa\sFROM\st1);\r\nCREATE\sINDEX\st1a\sON\st1(a)\sWHERE\sb=1;\r\nSELECT\s'two',\s*\sFROM\st2\sWHERE\sx\sNOT\sIN\s(SELECT\sa\sFROM\st1);\r\n</verbatim></blockquote>\r\n\r\nThis\sproblem\sappears\sto\shave\sbeen\sin\sthe\scode\ssince\spartial\sindexes\swere\sfirst\r\nintroduced\swith\sversion\s3.8.0\s(2013-08-26).\s\sThe\sproblem\swas\sfirst\sreported\son\s\r\nthe\suser\smailing\slist\sby\sDeon\sBrewis.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Incorrect\sresult\swith\sNOT\sIN\soperator\sand\spartial\sindex
J type Code_Defect
K 1d958d90596593a77420e590a6ab71756484f576
U drh
Z 566a18359548efe7d94d7270e7cae516