Import SQLite 3.8.7.4.

third_party/sqlite/src/test/e_update.test

 # 2010 September 20
 #
 # 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 31 matching lines @@
   CREATE TEMP TABLE t6(x, y);
 
   CREATE TABLE aux.t1(a, b);
   CREATE TABLE aux.t5(a, b);
 } {}
 
 proc do_update_tests {args} {
   uplevel do_select_tests $args
 }
 
-# EVIDENCE-OF: R-05685-44205 -- syntax diagram update-stmt
+# -- syntax diagram update-stmt
 #
 do_update_tests e_update-0 {
   1    "UPDATE t1 SET a=10" {}
   2    "UPDATE t1 SET a=10, b=5" {}
   3    "UPDATE t1 SET a=10 WHERE b=5" {}
   4    "UPDATE t1 SET b=5,a=10 WHERE 1" {}
   5    "UPDATE main.t1 SET a=10" {}
   6    "UPDATE main.t1 SET a=10, b=5" {}
   7    "UPDATE main.t1 SET a=10 WHERE b=5" {}
   9    "UPDATE OR ROLLBACK t1 SET a=10" {}
@@ skipping 163 matching lines @@
   5   "UPDATE t2 SET a = 3 WHERE c = 4"
       {3 1 4   1 5 9   1 2 2}
 
   6   "UPDATE t2 SET a = b WHERE rowid>2"
       {3 1 4   1 5 9   2 2 2}
 
   6   "UPDATE t2 SET b=6, c=5 WHERE a=b AND b=c"
       {3 1 4   1 5 9   2 6 5}
 }
 
-# EVIDENCE-OF: R-09060-20018 If a single column-name appears more than
+# EVIDENCE-OF: R-34751-18293 If a single column-name appears more than
 # once in the list of assignment expressions, all but the rightmost
-# occurence is ignored.
+# occurrence is ignored.
 #
 do_update_tests e_update-1.6 -query {
   SELECT * FROM t2
 } {
   1   "UPDATE t2 SET c=5, c=6, c=7 WHERE rowid=1" {3 1 7   1 5 9   2 6 5}
   2   "UPDATE t2 SET c=7, c=6, c=5 WHERE rowid=1" {3 1 5   1 5 9   2 6 5}
   3   "UPDATE t2 SET c=5, b=6, c=7 WHERE rowid=1" {3 6 7   1 5 9   2 6 5}
 }
 
 # EVIDENCE-OF: R-36239-04077 The scalar expressions may refer to columns
@@ skipping 22 matching lines @@
 #
 do_execsql_test e_update-1.8.0 {
   DELETE FROM t3;
   INSERT INTO t3 VALUES(1, 'one');
   INSERT INTO t3 VALUES(2, 'two');
   INSERT INTO t3 VALUES(3, 'three');
   INSERT INTO t3 VALUES(4, 'four');
 } {}
 foreach {tn sql error ac data } {
   1  "UPDATE t3 SET b='one' WHERE a=3" 
-     {column b is not unique} 1 {1 one 2 two 3 three 4 four}
+     {UNIQUE constraint failed: t3.b} 1 {1 one 2 two 3 three 4 four}
 
   2  "UPDATE OR REPLACE t3 SET b='one' WHERE a=3" 
      {} 1 {2 two 3 one 4 four}
 
   3  "UPDATE OR FAIL t3 SET b='three'"
-     {column b is not unique} 1 {2 three 3 one 4 four}
+     {UNIQUE constraint failed: t3.b} 1 {2 three 3 one 4 four}
 
   4  "UPDATE OR IGNORE t3 SET b='three' WHERE a=3" 
      {} 1 {2 three 3 one 4 four}
 
   5  "UPDATE OR ABORT t3 SET b='three' WHERE a=3" 
-     {column b is not unique} 1 {2 three 3 one 4 four}
+     {UNIQUE constraint failed: t3.b} 1 {2 three 3 one 4 four}
 
   6  "BEGIN" {} 0 {2 three 3 one 4 four}
 
   7  "UPDATE t3 SET b='three' WHERE a=3" 
-     {column b is not unique} 0 {2 three 3 one 4 four}
+     {UNIQUE constraint failed: t3.b} 0 {2 three 3 one 4 four}
 
   8  "UPDATE OR ABORT t3 SET b='three' WHERE a=3" 
-     {column b is not unique} 0 {2 three 3 one 4 four}
+     {UNIQUE constraint failed: t3.b} 0 {2 three 3 one 4 four}
 
   9  "UPDATE OR FAIL t3 SET b='two'"
-     {column b is not unique} 0 {2 two 3 one 4 four}
+     {UNIQUE constraint failed: t3.b} 0 {2 two 3 one 4 four}
 
   10 "UPDATE OR IGNORE t3 SET b='four' WHERE a=3"
      {} 0 {2 two 3 one 4 four}
 
   11 "UPDATE OR REPLACE t3 SET b='four' WHERE a=3"
      {} 0 {2 two 3 four}
 
   12 "UPDATE OR ROLLBACK t3 SET b='four'"
-     {column b is not unique} 1 {2 three 3 one 4 four}
+     {UNIQUE constraint failed: t3.b} 1 {2 three 3 one 4 four}
 } {
   do_catchsql_test e_update-1.8.$tn.1 $sql [list [expr {$error!=""}] $error]
   do_execsql_test  e_update-1.8.$tn.2 {SELECT * FROM t3} [list {*}$data]
   do_test          e_update-1.8.$tn.3 {sqlite3_get_autocommit db} $ac
 }
 
 
 
 # EVIDENCE-OF: R-12123-54095 The table-name specified as part of an
 # UPDATE statement within a trigger body must be unqualified.
@@ skipping 50 matching lines @@
 } {}
 
 # EVIDENCE-OF: R-29512-54644 If the table to which the trigger is
 # attached is in the TEMP database, then the unqualified name of the
 # table being updated is resolved in the same way as it is for a
 # top-level statement (by searching first the TEMP database, then the
 # main database, then any other databases in the order they were
 # attached).
 #
 do_execsql_test e_update-2.3.0 {
-  SELECT 'main', tbl_name FROM main.sqlite_master WHERE type = 'table'
-    UNION ALL
-  SELECT 'temp', tbl_name FROM sqlite_temp_master WHERE type = 'table'
-    UNION ALL
-  SELECT 'aux', tbl_name FROM aux.sqlite_master WHERE type = 'table'
+  SELECT 'main', tbl_name FROM main.sqlite_master WHERE type = 'table';
+  SELECT 'temp', tbl_name FROM sqlite_temp_master WHERE type = 'table';
+  SELECT 'aux', tbl_name FROM aux.sqlite_master WHERE type = 'table';
 } [list {*}{
     main t1
     main t2
     main t3
     main t6
     temp t4
     temp t6
     aux  t1
     aux  t5
 }]
@@ skipping 89 matching lines @@
         UPDATE t1 SET a=a+1 LIMIT 10 OFFSET 2;
       END;
   } {LIMIT}
 }
 
 # EVIDENCE-OF: R-59581-44104 If SQLite is built with the
 # SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option then the syntax
 # of the UPDATE statement is extended with optional ORDER BY and LIMIT
 # clauses
 #
-# EVIDENCE-OF: R-08948-01887 -- syntax diagram update-stmt-limited
+# -- syntax diagram update-stmt-limited
 #
 do_update_tests e_update-3.0 {
   1   "UPDATE t1 SET a=b LIMIT 5"                                    {}
   2   "UPDATE t1 SET a=b LIMIT 5-1 OFFSET 2+2"                       {}
   3   "UPDATE t1 SET a=b LIMIT 2+2, 16/4"                            {}
   4   "UPDATE t1 SET a=b ORDER BY a LIMIT 5"                         {}
   5   "UPDATE t1 SET a=b ORDER BY a LIMIT 5-1 OFFSET 2+2"            {}
   6   "UPDATE t1 SET a=b ORDER BY a LIMIT 2+2, 16/4"                 {}
   7   "UPDATE t1 SET a=b WHERE a>2 LIMIT 5"                          {}
   8   "UPDATE t1 SET a=b WHERE a>2 LIMIT 5-1 OFFSET 2+2"             {}
@@ skipping 89 matching lines @@
   1   "UPDATE t7 SET s = q ORDER BY r LIMIT -1"        {1 2 3 4 5 6 7 8 9 10}
   2   "UPDATE t7 SET s = q ORDER BY r ASC LIMIT -1"    {1 2 3 4 5 6 7 8 9 10}
   3   "UPDATE t7 SET s = q ORDER BY r DESC LIMIT -1"   {1 2 3 4 5 6 7 8 9 10}
   4   "UPDATE t7 SET s = q ORDER BY q DESC LIMIT 5"    {6 7 8 9 10}
 }
 
 
 } ;# ifcapable update_delete_limit
  
 finish_test
-