Overview
| Artifact ID: | 8f4098676a646bd103723c770df28efdbefdc93f |
|---|---|
| Ticket: | 4dd95f6943fbd18147bef88d4f211b466a8087df
Inverted result order with ORDER BY DESC and a DESC index. |
| User & Date: | drh 2013-03-12 17:34:34 |
Changes
- foundin changed to: "3.7.16"
- icomment:
The output from the following script occurs in the wrong order: <blockquote><verbatim> CREATE TABLE t1(x); INSERT INTO t1 VALUES(1),(2),(3),(4),(5),(6); CREATE INDEX t1xd ON t1(x DESC); SELECT x FROM t1 WHERE x IN (2,4,6) ORDER BY x DESC; </verbatim></blockquote> The problem appears to have been introduced by check-in [2cef8b68f0e1216] and has never been part of an official release. The problem was detected by the SQLLogicTest test harness during release testing. for version 3.7.16.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Critical"
- status changed to: "Open"
- title changed to:
Inverted result order with ORDER BY DESC and a DESC index.
- type changed to: "Code_Defect"