D 2014-08-27T17:28:30.127
J foundin 3.8.6
J icomment The\sSELECT\sstatement\sat\sthe\send\sof\sthe\sfollowing\sblock\sof\sSQL\soutputs\sno\r\nrows,\sbut\sit\sshould\soutput\sone\srow.\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a,\sb);\r\nCREATE\sTABLE\st2(c,\sd);\r\nINSERT\sINTO\st1\sVALUES(1,\s'xyz');\r\nINSERT\sINTO\st2\sVALUES('abc',\s'not\sxyz');\r\nCREATE\sINDEX\si2\sON\st2(c)\sWHERE\sd='xyz';\s\r\nSELECT\s*\sFROM\s(SELECT\s*\sFROM\st1\sWHERE\sa=1\sAND\sb='xyz'),\st2\sWHERE\sc='abc';\r\n</verbatim></blockquote>\r\n\r\nA\scorrect\sresult\sis\sobtained\sif\sthe\sindex\screated\son\sthe\spenultimate\sline\r\nis\sconvert\sinto\sa\scomplete\sindex\sor\sif\sthe\sindex\sis\somitted\sentirely.\r\n\r\nThis\sbug\sappears\sto\shave\sbeen\sin\sthe\simplementation\sof\spartial\sindexes\r\nfrom\stheir\sintroduction\sin\sSQLite\sversion\s3.8.0,\s2013-08-26.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Partial\sindex\sgives\sincorrect\squery\sresult
J type Code_Defect
K 02fe49582e2b0e183ed38f191464606929c781b6
U drh
Z 2f2e594deb39ec4ef9c0c02ccce47a4c