/ 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. foundin changed to: "3.7.16"
  2. 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.
    
  3. login: "drh"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Critical"
  6. status changed to: "Open"
  7. title changed to:
    Inverted result order with ORDER BY DESC and a DESC index.
    
  8. type changed to: "Code_Defect"