Return to tkt-c48d99d690.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

Annotation of embedaddon/sqlite3/test/tkt-c48d99d690.test, revision 1.1.1.1

1.1       misho       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
                     26: