D 2017-12-13T16:33:55.058
J foundin 3.21.0
J icomment The\squery\sin\sthe\sSQL\sbelow\sgets\sa\sdifferent\sanswer\safter\sthe\sindex\sis\r\ncreated.\s\sThe\sanswer\swithout\sthe\sindex\sis\scorrect.\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a,\sb);\s\sINSERT\sINTO\st1\sVALUES(1,2);\r\nCREATE\sTABLE\st2(x,\sy);\s\sINSERT\sINTO\st2\sVALUES(1,3);\r\nSELECT\sy\sFROM\st1,\st2\sWHERE\sa=x\sAND\sb<=y\sORDER\sBY\sb\sDESC;\r\nCREATE\sINDEX\st1ab\sON\st1(a,b);\r\nSELECT\sy\sFROM\st1,\st2\sWHERE\sa=x\sAND\sb<=y\sORDER\sBY\sb\sDESC;\r\n</verbatim></blockquote>\r\n\r\nThis\sproblem\sappears\sto\shave\sbeen\sintroduced\sby\scheck-in\s[559733b09e]\son\r\n2016-05-20,\s572\sdays\sago.\s\sThe\sproblem\sfirst\sappeared\sin\sversion\s3.14.0.\r\nThe\sproblem\swas\sdiscovered\sin\sthe\swild\sand\sreported\sto\sthe\sSQLite\sdevelopers\r\nvia\sprivate\semail.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Incorrect\sresult\swhen\san\sindex\sis\sused\sfor\san\sordered\sjoin
J type Code_Defect
K 123c9ba32130a6c9d43278229da12a076583005d
U drh
Z 630096741065741b49df75f2cea840e2