/ Ticket Change Details

Artifact ID: 41623a1ae46d5f40040d09475609b3f2aff75708
Ticket: a179fe746592d4aecc5c1ec2f6583a4e765e6ccf
Incorrect output order on a join with an ORDER BY
User & Date: drh 2013-03-27 11:39:51

  1. icomment:
    The ORDER BY clause on the final SELECT of the following script does not work:
    CREATE TABLE t1(a, b, PRIMARY KEY(a,b));
    INSERT INTO t1 VALUES(1,1),(1,2);
    CREATE TABLE t2(x, y, PRIMARY KEY(x,y));
    INSERT INTO t2 VALUES(3,3),(4,4);
    SELECT a, x FROM t1, t2 ORDER BY 1, 2;
    This script is a reduction of the same bug that causes the problem
    in the initial bug report above.
    This problem was introduced to trunk by check-in [956e4d7f8958e706] on
    2012-10-03 and first appeared in release 3.7.15.
  2. login: "drh"
  3. mimetype: "text/x-fossil-wiki"
  4. priority changed to: "Immediate"
  5. resolution changed to: "Open"
  6. subsystem changed to: "Unknown"
  7. title changed to: "Incorrect output order on a join with an ORDER BY"