[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/autoinc.test

 # 2004 November 12
 #
 # 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 326 matching lines @@
     SELECT name FROM sqlite_sequence;
   }
 } {}
 
 # AUTOINCREMENT on TEMP tables.
 #
 ifcapable tempdb {
   do_test autoinc-4.1 {
     execsql {
       SELECT 1, name FROM sqlite_master WHERE type='table';
-      SELECT 2, name FROM sqlite_temp_master WHERE type='table';
+      SELECT 2, name FROM temp.sqlite_master WHERE type='table';
     }
   } {1 sqlite_sequence}
   do_test autoinc-4.2 {
     execsql {
       CREATE TABLE t1(x INTEGER PRIMARY KEY AUTOINCREMENT, y);
       CREATE TEMP TABLE t3(a INTEGER PRIMARY KEY AUTOINCREMENT, b);
       SELECT 1, name FROM sqlite_master WHERE type='table';
       SELECT 2, name FROM sqlite_temp_master WHERE type='table';
     }
   } {1 sqlite_sequence 1 t1 2 t3 2 sqlite_sequence}
@@ skipping 298 matching lines @@
       CREATE VIEW va69637_2 AS SELECT * FROM ta69637_2;
       CREATE TRIGGER ra69637_2 INSTEAD OF INSERT ON va69637_2 BEGIN
         INSERT INTO ta69637_1(y) VALUES(new.z+10000);
       END;
       INSERT INTO va69637_2 VALUES(123);
       SELECT * FROM ta69637_1;
     }
   } {1 124 2 10123}
 }
 
+# 2016-10-03 ticket https://www.sqlite.org/src/tktview/7b3328086a5c1
+# Make sure autoincrement plays nicely with the xfer optimization
+#
+do_execsql_test autoinc-10.1 {
+  DELETE FROM sqlite_sequence;
+  CREATE TABLE t10a(a INTEGER PRIMARY KEY AUTOINCREMENT, b UNIQUE);
+  INSERT INTO t10a VALUES(888,9999);
+  CREATE TABLE t10b(x INTEGER PRIMARY KEY AUTOINCREMENT, y UNIQUE);
+  INSERT INTO t10b SELECT * FROM t10a;
+  SELECT * FROM sqlite_sequence;
+} {t10a 888 t10b 888}
+
 
 
 finish_test