1# 2016-05-10 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 12set testdir [file dirname $argv0] 13source $testdir/tester.tcl 14set testprefix temptable3 15 16db close 17sqlite3 db {} 18do_execsql_test 1.1 { 19 PRAGMA cache_size = 1; 20 PRAGMA page_size = 1024; 21 PRAGMA auto_vacuum = 2; 22 CREATE TABLE t1(x); 23 INSERT INTO t1 VALUES( randomblob(800) ); 24 INSERT INTO t1 VALUES( randomblob(800) ); 25 CREATE TABLE t2(x); 26 PRAGMA integrity_check; 27} {ok} 28 29db close 30sqlite3 db {} 31do_execsql_test 1.2 { 32 PRAGMA cache_size = 1; 33 PRAGMA auto_vacuum = 2; 34 CREATE TABLE t1(x); 35 CREATE TABLE t2(x UNIQUE); 36 INSERT INTO t2 VALUES(1), (2), (3); 37 DROP TABLE t1; 38 PRAGMA integrity_check; 39} {ok} 40 41finish_test 42