Import SQLite 3.10.2.

third_party/sqlite/src/test/e_insert.test

 # 2010 September 18
 #
 # 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 139 matching lines @@
     1a   "INSERT INTO a2 VALUES(1, 2, 3)"    {}
     1b   "SELECT count(*) FROM a2"           {1}
 
     2a   "INSERT INTO a2(a, b) VALUES(1, 2)" {}
     2b   "SELECT count(*) FROM a2"           {2}
 
     3a   "INSERT INTO a2(a) VALUES(3),(4)"   {}
     3b   "SELECT count(*) FROM a2"           {4}
 }
 
-# EVIDENCE-OF: R-53616-44976 If no column-list is specified then the
-# number of values inserted into each row must be the same as the number
-# of columns in the table.
+# EVIDENCE-OF: R-19218-01018 If the column-name list after table-name is
+# omitted then the number of values inserted into each row must be the
+# same as the number of columns in the table.
 #
 #   A test in the block above verifies that if the VALUES list has the
 #   correct number of columns (for table a2, 3 columns) works. So these
 #   tests just show that other values cause an error.
 #
 do_insert_tests e_insert-1.2 -error { 
   table %s has %d columns but %d values were supplied
 } {
     1    "INSERT INTO a2 VALUES(1)"         {a2 3 1}
     2    "INSERT INTO a2 VALUES(1,2)"       {a2 3 2}
@@ skipping 11 matching lines @@
     1a   "INSERT INTO a2 VALUES(1, 2, 3)"    {}
     1b   "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {1 2 3}
 
     2a   "INSERT INTO a2 VALUES('abc', NULL, 3*3+1)"      {}
     2b   "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {abc {} 10}
 
     3a   "INSERT INTO a2 VALUES((SELECT count(*) FROM a2), 'x', 'y')" {}
     3b   "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {2 x y}
 }
 
-# EVIDENCE-OF: R-09234-17933 If a column-list is specified, then the
-# number of values in each term of the VALUE list must match the number
-# of specified columns.
+# EVIDENCE-OF: R-21115-58321 If a column-name list is specified, then
+# the number of values in each term of the VALUE list must match the
+# number of specified columns.
 #
 do_insert_tests e_insert-1.4 -error { 
   %d values for %d columns
 } {
     1    "INSERT INTO a2(a, b, c) VALUES(1)"         {1 3}
     2    "INSERT INTO a2(a, b, c) VALUES(1,2)"       {2 3}
     3    "INSERT INTO a2(a, b, c) VALUES(1,2,3,4)"   {4 3}
     4    "INSERT INTO a2(a, b, c) VALUES(1,2,3,4,5)" {5 3}
 
     5    "INSERT INTO a2(c, a) VALUES(1)"            {1 2}
@@ skipping 134 matching lines @@
     4.1    "INSERT INTO a2 DEFAULT VALUES"     {}
     4.2    "SELECT * FROM a2"                  {{} {} xyz {} {} xyz}
 
     5.1    "INSERT INTO a1 DEFAULT VALUES"     {}
     5.2    "SELECT * FROM a1"                  {{} {}}
 
     6.1    "INSERT INTO a1 DEFAULT VALUES"     {}
     6.2    "SELECT * FROM a1"                  {{} {} {} {}}
 }
 
-# EVIDENCE-OF: R-46928-50290 The optional conflict-clause allows the
-# specification of an alternative constraint conflict resolution
-# algorithm to use during this one INSERT command.
+# EVIDENCE-OF: R-03235-45250 The "REPLACE" and "INSERT OR action" forms
+# specify an alternative constraint conflict resolution algorithm to use
+# during this one INSERT command.
 #
 # EVIDENCE-OF: R-23110-47146 the parser allows the use of the single
 # keyword REPLACE as an alias for "INSERT OR REPLACE".
 #
 #    The two requirements above are tested by e_select-4.1.* and
 #    e_select-4.2.*, respectively.
 #
 # EVIDENCE-OF: R-03421-22330 The REPLACE command is an alias for the
 # "INSERT OR REPLACE" variant of the INSERT command.
 #
@@ skipping 23 matching lines @@
 
   2.1  "INSERT INTO a4 VALUES(2,'f')"  
         {UNIQUE constraint failed: a4.c}  1 {1 a 3 a 2 b 4 e}
   2.2  "REPLACE INTO a4 VALUES(2, 'f')" {}  1 {1 a 3 a 4 e 2 f}
 } {
   do_catchsql_test e_insert-4.1.$tn.1 $sql [list [expr {$error!=""}] $error]
   do_execsql_test  e_insert-4.1.$tn.2 {SELECT * FROM a4} [list {*}$data]
   do_test          e_insert-4.1.$tn.3 {sqlite3_get_autocommit db} $ac
 }
 
-# EVIDENCE-OF: R-64196-02418 The optional "database-name." prefix on the
-# table-name is support for top-level INSERT statements only.
+# EVIDENCE-OF: R-59829-49719 The optional "schema-name." prefix on the
+# table-name is supported for top-level INSERT statements only.
 #
 # EVIDENCE-OF: R-05731-00924 The table name must be unqualified for
 # INSERT statements that occur within CREATE TRIGGER statements.
 #
 set err {1 {qualified table names are not allowed on INSERT, UPDATE, and DELETE statements within triggers}}
 
 do_catchsql_test e_insert-5.1.1 {
   CREATE TRIGGER AFTER UPDATE ON a1 BEGIN
     INSERT INTO main.a4 VALUES(new.a, new.b);
   END;
@@ skipping 12 matching lines @@
 do_catchsql_test e_insert-5.2.1 {
   CREATE TRIGGER AFTER UPDATE ON a1 BEGIN
     INSERT INTO a4 DEFAULT VALUES;
   END;
 } {1 {near "DEFAULT": syntax error}}
 
 
 delete_all_data
 
 finish_test