Ticket Hash: | 4dd95f6943fbd18147bef88d4f211b466a8087df | |||
Title: | Inverted result order with ORDER BY DESC and a DESC index. | |||
Status: | Fixed | Type: | Code_Defect | |
Severity: | Critical | Priority: | Immediate | |
Subsystem: | Unknown | Resolution: | Fixed | |
Last Modified: | 2013-03-13 00:13:54 | |||
Version Found In: | 3.7.16 | |||
User Comments: | ||||
drh added on 2013-03-12 17:34:34:
The output from the following script occurs in the wrong order: 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; 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. |