Import SQLite 3.10.2.

third_party/sqlite/src/test/insert2.test

 # 2001 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.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing the INSERT statement that takes is
 # result from a SELECT.
 #
 # $Id: insert2.test,v 1.19 2008/01/16 18:20:42 danielk1977 Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
+set testprefix insert2
 
 # Create some tables with data that we can select against
 #
 do_test insert2-1.0 {
   execsql {CREATE TABLE d1(n int, log int);}
   for {set i 1} {$i<=20} {incr i} {
     for {set j 0} {(1<<$j)<$i} {incr j} {}
     execsql "INSERT INTO d1 VALUES($i,$j)"
   }
   execsql {SELECT * FROM d1 ORDER BY n}
@@ skipping 239 matching lines @@
 } {1 2 1 3}
 ifcapable subquery {
   do_test insert2-5.2 {
     execsql {
       INSERT INTO t2 SELECT (SELECT a FROM t2), 4;
       SELECT * FROM t2;
     }
   } {1 2 1 3 1 4}
 }
 
+do_execsql_test 6.0 { 
+  CREATE TABLE t5(a, b, c DEFAULT 'c', d);
+}
+do_execsql_test 6.1 {
+  INSERT INTO t5(a) SELECT 456 UNION ALL SELECT 123 ORDER BY 1;
+  SELECT * FROM t5 ORDER BY rowid;
+} {123 {} c {}   456 {} c {}}
+
+ifcapable fts3 {
+  do_execsql_test 6.2 {
+    CREATE VIRTUAL TABLE t0 USING fts4(a);
+  }
+  do_execsql_test 6.3 {
+    INSERT INTO t0 SELECT 0 UNION SELECT 0 AS 'x' ORDER BY x;
+    SELECT * FROM t0;
+  } {0}
+}
+
+
 finish_test