3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
10 #***********************************************************************
13 set testdir [file dirname $argv0]
14 source $testdir/tester.tcl
19 CREATE TABLE t1(a, b, c, d);
20 CREATE INDEX i1 ON t1(a, b, c);
24 SELECT * FROM t1 ORDER BY a, b, c
27 `--SCAN t1 USING INDEX i1
32 SELECT * FROM t1 ORDER BY a, b, +c
35 |--SCAN t1 USING INDEX i1
36 `--USE TEMP B-TREE FOR LAST TERM OF ORDER BY
40 SELECT * FROM t1 ORDER BY a, +b, +c
43 |--SCAN t1 USING INDEX i1
44 `--USE TEMP B-TREE FOR LAST 2 TERMS OF ORDER BY