/ Ticket Change Details
Login
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

  1. Change foundin to "3.7.16"
  2. Change icomment to:

    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.

  3. Change login to "drh"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to:

    Inverted result order with ORDER BY DESC and a DESC index.

  8. Change type to "Code_Defect"