Annotation of embedaddon/sqlite3/test/tkt-c48d99d690.test, revision 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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>