D 2016-10-12T14:00:28.514
J foundin 3.14.2
J icomment The\ssecond\squery\sin\sthe\sfollowing\sSQL\sreturns\san\sincorrect\sresult:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(x\sINTEGER\sPRIMARY\sKEY,\sy\sINT);\r\nINSERT\sINTO\st1(x,y)\sVALUES(1,1),(2,1),(3,1),(4,1),(5,5),(6,6),(7,4);\r\nCREATE\sTABLE\st2(z\sINT);\r\nINSERT\sINTO\st2(z)\sVALUES(1),(2),(3),(4),(5),(6),(7);\r\nSELECT\s1,x,y\sFROM\st1\sWHERE\sx\sIN\s(SELECT\sz\sFROM\st2)\sORDER\sBY\sy\sDESC;\r\nSELECT\s2,x,y\sFROM\st1\sWHERE\sx\sIN\s(SELECT\sz\sFROM\st2)\sORDER\sBY\sy\sDESC\sLIMIT\s3;\r\n</verbatim></blockquote>\r\n\r\nThis\sproblem\sfirst\sappeared\swith\sthe\sORDER\sBY\sLIMIT\soptimization\sof\r\ncheck-in\s[559733b09e9630fa]\son\s2016-05-20\sand\sfirst\sappeared\sin\sthe\s3.14.0\r\nrelease.\s\sThe\sproblem\swas\sreported\son\sthe\smailing\slist\sby\sKeith\sMedcalf.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Incorrect\sresult\swith\sORDER\sBY\sDESC\sand\sLIMIT\s(again)
J type Code_Defect
K 96c1454cbfd9509a1808b686ed11138715164869
U drh
Z 6cbcbd0589e5383e36266cca3f5428b7