gitlab.com/CoiaPrant/sqlite3@v1.19.1/testdata/tcl/sorterref.test (about)

     1  # 2018 April 14.
     2  #
     3  # The author disclaims copyright to this source code.  In place of
     4  # a legal notice, here is a blessing:
     5  #
     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.
     9  #
    10  #***********************************************************************
    11  #
    12  
    13  set testdir [file dirname $argv0]
    14  source $testdir/tester.tcl
    15  set testprefix sorterref
    16  
    17  # If SQLITE_OMIT_ALTERTABLE is defined, omit this file.
    18  ifcapable !altertable {
    19    finish_test
    20    return
    21  }
    22  
    23  do_execsql_test 1.0 {
    24    CREATE TABLE t1(a, b, c);
    25    INSERT INTO t1 VALUES(1, 2, 3);
    26    INSERT INTO t1 VALUES(4, 5, 6);
    27    ALTER TABLE t1 ADD COLUMN d DEFAULT 'string';
    28    INSERT INTO t1 VALUES(7, 8, 9, 'text');
    29  }
    30  
    31  do_execsql_test 1.1 {
    32    SELECT * FROM t1 ORDER BY b;
    33  } {
    34    1 2 3 string 4 5 6 string 7 8 9 text
    35  }
    36  
    37  do_execsql_test 2.0 {
    38    DROP TABLE IF EXISTS t1;
    39    CREATE TABLE t1(a, b);
    40    CREATE TABLE t2(c, d, PRIMARY KEY(c)) WITHOUT ROWID;
    41  
    42    INSERT INTO t1 VALUES(1, 2);
    43    INSERT INTO t1 VALUES(2, 3);
    44    INSERT INTO t1 VALUES(3, 4);
    45  
    46    INSERT INTO t2 VALUES(1, 'one');
    47    INSERT INTO t2 VALUES(3, 'three');
    48  }
    49  
    50  do_execsql_test 2.1 {
    51    SELECT * FROM t1 LEFT JOIN t2 ON (a=c) ORDER BY b;
    52  } {1 2 1 one 2 3 {} {} 3 4 3 three}
    53  
    54  
    55  
    56  finish_test