gitlab.com/CoiaPrant/sqlite3@v1.19.1/testdata/tcl/tkt-c48d99d690.test (about)

     1  
     2  set testdir [file dirname $argv0]
     3  source $testdir/tester.tcl
     4  
     5  set ::testprefix tkt-c48d99d690
     6  
     7  do_test 1.0 {
     8    execsql {
     9      CREATE TABLE t1(a, b);
    10      CREATE TABLE t2(a, b);
    11      INSERT INTO t1 VALUES('one'  , 1);
    12      INSERT INTO t1 VALUES('two'  , 5);
    13      INSERT INTO t1 VALUES('two'  , 2);
    14      INSERT INTO t1 VALUES('three', 3);
    15      PRAGMA count_changes = 1;
    16    }
    17  } {}
    18  
    19  do_test 1.1 {
    20    execsql { INSERT INTO t2 SELECT * FROM t1 }
    21  } {4}
    22  
    23  do_test 1.2 { execsql VACUUM } {}
    24  
    25  finish_test