Move bundled copy of sqlite one level deeper to better separate it...

third_party/sqlite/test/createtab.test

-# 2007 May 02
-#
-# The author disclaims copyright to this source code.  In place of
-# a legal notice, here is a blessing:
-#
-#    May you do good and not evil.
-#    May you find forgiveness for yourself and forgive others.
-#    May you share freely, never taking more than you give.
-#
-#***********************************************************************
-# This file implements regression tests for SQLite library.  The
-# focus of this file is testing that it is OK to create new tables
-# and indices while creating existing tables and indices.
-#
-# $Id: createtab.test,v 1.3 2007/09/12 17:01:45 danielk1977 Exp $
-
-set testdir [file dirname $argv0]
-source $testdir/tester.tcl
-
-ifcapable autovacuum {
-  set upperBound 2
-} else {
-  set upperBound 0
-}
-
-# Run these tests for all possible values of autovacuum.
-#
-for {set av 0} {$av<=$upperBound} {incr av} {
-  db close
-  file delete -force test.db test.db-journal
-  sqlite3 db test.db
-
-  # Create a table that spans multiple pages.  It is important
-  # that part of the database be in pages beyond the root page.
-  #
-  do_test createtab-$av.1 {
-    execsql "PRAGMA auto_vacuum=$av"
-    execsql {
-      PRAGMA page_size=1024;
-      CREATE TABLE t1(x INTEGER PRIMARY KEY, y);
-      INSERT INTO t1 VALUES(1, hex(randomblob(200)));
-      INSERT INTO t1 VALUES(2, hex(randomblob(200)));
-      INSERT INTO t1 VALUES(3, hex(randomblob(200)));
-      INSERT INTO t1 VALUES(4, hex(randomblob(200)));
-      SELECT count(*) FROM t1;
-    }
-  } {4}
-
-  set isUtf16 0
-  ifcapable utf16 { 
-    set isUtf16 [expr {[execsql {PRAGMA encoding}] != "UTF-8"}]
-  }
-
-  do_test createtab-$av.2 {
-    file size test.db
-  } [expr {1024*(4+($av!=0)+(${isUtf16}*2))}]
-  
-  # Start reading the table
-  #
-  do_test createtab-$av.3 {
-    set STMT [sqlite3_prepare db {SELECT x FROM t1} -1 TAIL]
-    sqlite3_step $STMT
-  } {SQLITE_ROW}
-  do_test createtab-$av.4 {
-    sqlite3_column_int $STMT 0
-  } {1}
-  
-  # While still reading the table, create a new table.
-  #
-  do_test createtab-$av.5 {
-    execsql {
-      CREATE TABLE t2(a,b);
-      INSERT INTO t2 VALUES(1,2);
-      SELECT * FROM t2;
-    }
-  } {1 2}
-  
-  # Continue reading the original table.
-  #
-  do_test createtab-$av.6 {
-    sqlite3_column_int $STMT 0
-  } {1}
-  do_test createtab-$av.7 {
-    sqlite3_step $STMT
-  } {SQLITE_ROW}
-  do_test createtab-$av.8 {
-    sqlite3_column_int $STMT 0
-  } {2}
-  
-  # Do another cycle of creating a new database table while contining
-  # to read the original table.
-  #
-  do_test createtab-$av.11 {
-    execsql {
-      CREATE TABLE t3(a,b);
-      INSERT INTO t3 VALUES(4,5);
-      SELECT * FROM t3;
-    }
-  } {4 5}
-  do_test createtab-$av.12 {
-    sqlite3_column_int $STMT 0
-  } {2}
-  do_test createtab-$av.13 {
-    sqlite3_step $STMT
-  } {SQLITE_ROW}
-  do_test createtab-$av.14 {
-    sqlite3_column_int $STMT 0
-  } {3}
-  
-  # One more cycle.
-  #
-  do_test createtab-$av.21 {
-    execsql {
-      CREATE TABLE t4(a,b);
-      INSERT INTO t4 VALUES('abc','xyz');
-      SELECT * FROM t4;
-    }
-  } {abc xyz}
-  do_test createtab-$av.22 {
-    sqlite3_column_int $STMT 0
-  } {3}
-  do_test createtab-$av.23 {
-    sqlite3_step $STMT
-  } {SQLITE_ROW}
-  do_test createtab-$av.24 {
-    sqlite3_column_int $STMT 0
-  } {4}
-  
-  # Finish reading.  Do an integrity check on the database.
-  #
-  do_test createtab-$av.30 {
-    sqlite3_step $STMT
-  } {SQLITE_DONE}
-  do_test createtab-$av.31 {
-    sqlite3_finalize $STMT
-  } {SQLITE_OK}
-  do_test createtab-$av.32 {
-    execsql {
-      SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1
-    }
-  } {t1 t2 t3 t4}
-  integrity_check createtab-$av.40
-
-}
-  
-finish_test