[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/without_rowid3.test

 # 2013-11-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.
 #
 #***********************************************************************
@@ skipping 1013 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 without_rowid3-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 without_rowid3-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 without_rowid3-14.2tmp.1.1 {
     test_rename_parent {CREATE TABLE t1(a REFERENCES t2)} t2 t3
   } {{CREATE TABLE t1(a REFERENCES "t3")}}
   do_test without_rowid3-14.2tmp.1.2 {
     test_rename_parent {CREATE TABLE t1(a REFERENCES t2)} t4 t3
   } {{CREATE TABLE t1(a REFERENCES t2)}}
   do_test without_rowid3-14.2tmp.1.3 {
@@ skipping 12 matching lines @@
     }
     execsql { SELECT sql FROM sqlite_temp_master WHERE type = 'table'}
   } [list \
     {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1) WITHOUT rowid}       \
     {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)
             WITHOUT rowid}    \
     {CREATE TABLE t3(a REFERENCES t1, b REFERENCES t2, c REFERENCES t1)}  \
   ]
   do_test without_rowid3-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") WITHOUT rowid}      \
     {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)
             WITHOUT rowid}     \
     {CREATE TABLE t3(a REFERENCES "t4", b REFERENCES t2, c REFERENCES "t4")} \
   ]
   do_test without_rowid3-14.2tmp.2.3 {
     catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
   } {1 {FOREIGN KEY constraint failed}}
   do_test without_rowid3-14.2tmp.2.4 {
@@ skipping 1013 matching lines @@
   CREATE TABLE t2(a,b,PRIMARY KEY(a,b)) WITHOUT ROWID;
   INSERT INTO t1 VALUES(1,2),(3,4),(5,6);
   SELECT changes();
 } {3}
 do_execsql_test without_rowid3-30.2 {
   INSERT INTO t2 SELECT * FROM t1;
   SELECT changes();
 } {3}
 
 finish_test