SQLite

Artifact [1f188ca25a]
Login

Artifact 1f188ca25a2a7175d6be59dd21c95984c2cd1ea564fc291c8180b4619dda9e07:

Ticket change [1f188ca25a] - New ticket [9cdc5c4662] Incorrect result from second execution of correlated scalar sub-query that uses a partial sort. by dan 2019-06-26 20:00:00.
D 2019-06-26T20:00:00.464
J icomment <verbatim>\r\nCREATE\sTABLE\st1(x);\r\nINSERT\sINTO\st1\sVALUES('ALFKI');\r\nINSERT\sINTO\st1\sVALUES('ANATR');\r\n\r\nCREATE\sTABLE\st2(y,\sz);\r\nCREATE\sINDEX\st2y\sON\st2\s(y);\r\nINSERT\sINTO\st2\sVALUES('ANATR',\s'1997-08-08\s00:00:00');\r\nINSERT\sINTO\st2\sVALUES('ALFKI',\s'1997-08-25\s00:00:00');\r\n\r\nSELECT\s(\r\n\s\sSELECT\sy\sFROM\st2\sWHERE\sx\s=\sy\sORDER\sBY\sy,\sz\r\n)\r\nFROM\st1;\r\n</verbatim>\r\n\r\nThe\sscript\sabove\sshould\sreturn\stwo\srows\s-\sone\swith\s'ANATR'\sand\sa\ssecond\swith\s'ALFKI'.\sInstead\sit\sreturns\s'ANATR'\sand\sthen\sNULL.\r\n\r\nProblem\sintroduced\sby\scommit\s[4678cb1044f0b].
J login dan
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Incorrect\sresult\sfrom\ssecond\sexecution\sof\scorrelated\sscalar\ssub-query\sthat\suses\sa\spartial\ssort
J type Code_Defect
K 9cdc5c4662d4063771d45d2893b294df0e868001
U dan
Z 3c83056fc4458b0dca4c9f8653ef71de