Debian Codegraph @

test/tkt-c48d99d690.test

raw
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