SQLite

Artifact [8f409867]
Login

Artifact 8f4098676a646bd103723c770df28efdbefdc93f:

Ticket change [8f409867] - New ticket [4dd95f69] Inverted result order with ORDER BY DESC and a DESC index.. by drh 2013-03-12 17:34:34.
D 2013-03-12T17:34:34.294
J foundin 3.7.16
J icomment The\soutput\sfrom\sthe\sfollowing\sscript\soccurs\sin\sthe\swrong\sorder:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(x);\r\nINSERT\sINTO\st1\sVALUES(1),(2),(3),(4),(5),(6);\r\nCREATE\sINDEX\st1xd\sON\st1(x\sDESC);\r\nSELECT\sx\sFROM\st1\sWHERE\sx\sIN\s(2,4,6)\sORDER\sBY\sx\sDESC;\r\n</verbatim></blockquote>\r\n\r\nThe\sproblem\sappears\sto\shave\sbeen\sintroduced\sby\scheck-in\r\n[2cef8b68f0e1216]\sand\shas\snever\sbeen\spart\sof\san\sofficial\r\nrelease.\s\sThe\sproblem\swas\sdetected\sby\sthe\sSQLLogicTest\r\ntest\sharness\sduring\srelease\stesting.\sfor\sversion\s3.7.16.
J login drh
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Inverted\sresult\sorder\swith\sORDER\sBY\sDESC\sand\sa\sDESC\sindex.
J type Code_Defect
K 4dd95f6943fbd18147bef88d4f211b466a8087df
U drh
Z 890069ae57fdae016a0efb4a711fcdd8