1d12bc602Sdrh# 2016-05-10 2d12bc602Sdrh# 3d12bc602Sdrh# The author disclaims copyright to this source code. In place of 4d12bc602Sdrh# a legal notice, here is a blessing: 5d12bc602Sdrh# 6d12bc602Sdrh# May you do good and not evil. 7d12bc602Sdrh# May you find forgiveness for yourself and forgive others. 8d12bc602Sdrh# May you share freely, never taking more than you give. 9d12bc602Sdrh# 10d12bc602Sdrh#*********************************************************************** 11d12bc602Sdrh 12d12bc602Sdrhset testdir [file dirname $argv0] 13d12bc602Sdrhsource $testdir/tester.tcl 14d12bc602Sdrhset testprefix temptable3 15d12bc602Sdrh 16d12bc602Sdrhdb close 17d12bc602Sdrhsqlite3 db {} 18d12bc602Sdrhdo_execsql_test 1.1 { 19d12bc602Sdrh PRAGMA cache_size = 1; 20d12bc602Sdrh PRAGMA page_size = 1024; 21d12bc602Sdrh PRAGMA auto_vacuum = 2; 22d12bc602Sdrh CREATE TABLE t1(x); 23d12bc602Sdrh INSERT INTO t1 VALUES( randomblob(800) ); 24d12bc602Sdrh INSERT INTO t1 VALUES( randomblob(800) ); 25d12bc602Sdrh CREATE TABLE t2(x); 26d12bc602Sdrh PRAGMA integrity_check; 27d12bc602Sdrh} {ok} 28d12bc602Sdrh 29*78d1c905Sdandb close 30*78d1c905Sdansqlite3 db {} 31*78d1c905Sdando_execsql_test 1.2 { 32*78d1c905Sdan PRAGMA cache_size = 1; 33*78d1c905Sdan PRAGMA auto_vacuum = 2; 34*78d1c905Sdan CREATE TABLE t1(x); 35*78d1c905Sdan CREATE TABLE t2(x UNIQUE); 36*78d1c905Sdan INSERT INTO t2 VALUES(1), (2), (3); 37*78d1c905Sdan DROP TABLE t1; 38*78d1c905Sdan PRAGMA integrity_check; 39*78d1c905Sdan} {ok} 40*78d1c905Sdan 41d12bc602Sdrhfinish_test 42