[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/alter.test

 # 2004 November 10
 #
 # 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 59 matching lines @@
 } {t1 1 2 t1'x1 3 4 5 6 7}
 do_test alter-1.2 {
   execsql [subst {
     CREATE $::temp TABLE objlist(type, name, tbl_name);
     INSERT INTO objlist SELECT type, name, tbl_name 
         FROM sqlite_master WHERE NAME!='objlist';
   }]
   ifcapable tempdb {
     execsql {
       INSERT INTO objlist SELECT type, name, tbl_name 
-          FROM sqlite_temp_master WHERE NAME!='objlist';
+          FROM temp.sqlite_master WHERE NAME!='objlist';
     }
   }
 
   execsql {
     SELECT type, name, tbl_name FROM objlist ORDER BY tbl_name, type desc, name;
   }
 } [list \
      table t1                              t1             \
      index t1i1                            t1             \
      index t1i2                            t1             \
@@ skipping 55 matching lines @@
 #
 ifcapable tempdb {
   do_test alter-1.6 {
     db close
     sqlite3 db test.db
     set DB [sqlite3_connection_pointer db]
     execsql {
       CREATE TEMP TABLE objlist(type, name, tbl_name);
       INSERT INTO objlist SELECT type, name, tbl_name FROM sqlite_master;
       INSERT INTO objlist 
-          SELECT type, name, tbl_name FROM sqlite_temp_master 
+          SELECT type, name, tbl_name FROM temp.sqlite_master 
           WHERE NAME!='objlist';
       SELECT type, name, tbl_name FROM objlist 
           ORDER BY tbl_name, type desc, name;
     }
   } [list \
        table -t1-                         -t1-           \
        index t1i1                         -t1-           \
        index t1i2                         -t1-           \
        table T2                           T2          \
        index i3                           T2          \
@@ skipping 350 matching lines @@
   set ::TRIGGER
 } {trig2 G h i}
 do_test alter-3.3.7 {
   execsql {
     DROP TABLE tbl3;
   }
 } {}
 ifcapable tempdb {
   do_test alter-3.3.8 {
     execsql {
-      SELECT * FROM sqlite_temp_master WHERE type = 'trigger';
+      SELECT * FROM temp.sqlite_master WHERE type = 'trigger';
     }
   } {}
 }
 
 } ;# ifcapable trigger
 
 # If the build does not include AUTOINCREMENT fields, omit alter-4.*.
 ifcapable autoinc {
 
 do_test alter-4.1 {
@@ skipping 378 matching lines @@
   SELECT sqlite_rename_parent('create references ''','abc','xyz');
 } {{create references '}}
 do_execsql_test alter-17.12 {
   SELECT sqlite_rename_parent('create references "abc"123" ','abc','xyz');
 } {{create references "xyz"123" }}
 do_execsql_test alter-17.13 {
   SELECT sqlite_rename_parent("references '''",'abc','xyz');
 } {{references '''}}
 
 finish_test