AryaWu/sqlite

1# 2016-05-102#3# The author disclaims copyright to this source code.  In place of4# 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.tcl14set testprefix temptable315 16db close17sqlite3 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 close30sqlite3 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_test42