[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/fkey2.test

 # 2009 September 15
 #
 # 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.
 #
 #***********************************************************************
@@ skipping 1044 matching lines @@
     catchsql { ALTER TABLE t2 ADD COLUMN f REFERENCES t1 DEFAULT 'text'}
   } {1 {Cannot add a REFERENCES column with non-NULL default value}}
   do_test fkey2-14.1tmp.5 {
     catchsql { ALTER TABLE t2 ADD COLUMN g DEFAULT CURRENT_TIME REFERENCES t1 }
   } {1 {Cannot add a REFERENCES column with non-NULL default value}}
   do_test fkey2-14.1tmp.6 {
     execsql { 
       PRAGMA foreign_keys = off;
       ALTER TABLE t2 ADD COLUMN h DEFAULT 'text' REFERENCES t1;
       PRAGMA foreign_keys = on;
-      SELECT sql FROM sqlite_temp_master WHERE name='t2';
+      SELECT sql FROM temp.sqlite_master WHERE name='t2';
     }
   } {{CREATE TABLE t2(a, b, c REFERENCES t1, d DEFAULT NULL REFERENCES t1, e REFERENCES t1 DEFAULT NULL, h DEFAULT 'text' REFERENCES t1)}}
 
   do_test fkey2-14.2tmp.1.1 {
     test_rename_parent {CREATE TABLE t1(a REFERENCES t2)} t2 t3
   } {{CREATE TABLE t1(a REFERENCES "t3")}}
   do_test fkey2-14.2tmp.1.2 {
     test_rename_parent {CREATE TABLE t1(a REFERENCES t2)} t4 t3
   } {{CREATE TABLE t1(a REFERENCES t2)}}
   do_test fkey2-14.2tmp.1.3 {
@@ skipping 10 matching lines @@
       CREATE TEMP TABLE t3(a REFERENCES t1, b REFERENCES t2, c REFERENCES t1);
     }
     execsql { SELECT sql FROM sqlite_temp_master WHERE type = 'table'}
   } [list \
     {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1)}                     \
     {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)}    \
     {CREATE TABLE t3(a REFERENCES t1, b REFERENCES t2, c REFERENCES t1)}  \
   ]
   do_test fkey2-14.2tmp.2.2 {
     execsql { ALTER TABLE t1 RENAME TO t4 }
-    execsql { SELECT sql FROM sqlite_temp_master WHERE type = 'table'}
+    execsql { SELECT sql FROM temp.sqlite_master WHERE type = 'table'}
   } [list \
     {CREATE TABLE "t4"(a PRIMARY KEY, b REFERENCES "t4")}                    \
     {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)}     \
     {CREATE TABLE t3(a REFERENCES "t4", b REFERENCES t2, c REFERENCES "t4")} \
   ]
   do_test fkey2-14.2tmp.2.3 {
     catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
   } {1 {FOREIGN KEY constraint failed}}
   do_test fkey2-14.2tmp.2.4 {
     execsql { INSERT INTO t4 VALUES(1, NULL) }
@@ skipping 920 matching lines @@
   catchsql {
     PRAGMA foreign_keys=1;
     CREATE TABLE t1(x PRIMARY KEY);
     CREATE TABLE t(y REFERENCES t0(x)ON DELETE SET DEFAULT);
     CREATE TABLE t0(y REFERENCES t1 ON DELETE SET NULL);
     REPLACE INTO t1 SELECT(0);CREATE TABLE t2(x);CREATE TABLE t3;
   }
 } {1 {foreign key mismatch - "t" referencing "t0"}}
 
 finish_test