Import SQLite 3.10.2.

third_party/sqlite/src/test/e_delete.test

 # 2010 September 21
 #
 # 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 52 matching lines @@
         INSERT INTO %T% VALUES(5, 'five');
       }]
     }
   }
 } {}
 do_delete_tests e_delete-1.1 {
   1  "DELETE FROM t1       ; SELECT * FROM t1"       {}
   2  "DELETE FROM main.t2  ; SELECT * FROM t2"       {}
 }
 
-# EVIDENCE-OF: R-30203-16177 If a WHERE clause is supplied, then only
-# those rows for which the result of evaluating the WHERE clause as a
-# boolean expression is true are deleted.
+# EVIDENCE-OF: R-26300-50198 If a WHERE clause is supplied, then only
+# those rows for which the WHERE clause boolean expression is true are
+# deleted.
+#
+# EVIDENCE-OF: R-23360-48280 Rows for which the expression is false or
+# NULL are retained.
 #
 do_delete_tests e_delete-1.2 {
   1  "DELETE FROM t3 WHERE 1       ; SELECT x FROM t3"       {}
   2  "DELETE FROM main.t4 WHERE 0  ; SELECT x FROM t4"       {1 2 3 4 5}
   3  "DELETE FROM t4 WHERE 0.0     ; SELECT x FROM t4"       {1 2 3 4 5}
   4  "DELETE FROM t4 WHERE NULL    ; SELECT x FROM t4"       {1 2 3 4 5}
   5  "DELETE FROM t4 WHERE y!='two'; SELECT x FROM t4"       {2}
   6  "DELETE FROM t4 WHERE y='two' ; SELECT x FROM t4"       {}
   7  "DELETE FROM t5 WHERE x=(SELECT max(x) FROM t5);SELECT x FROM t5" {1 2 3 4}
   8  "DELETE FROM t5 WHERE (SELECT max(x) FROM t4)  ;SELECT x FROM t5" {1 2 3 4}
@@ skipping 24 matching lines @@
   CREATE TABLE aux.t9(a, b);    INSERT INTO aux.t9 VALUES(1, 2);
   CREATE TABLE aux2.t9(a, b);   INSERT INTO aux2.t9 VALUES(3, 4);
 
   CREATE TABLE aux2.t10(a, b);  INSERT INTO aux2.t10 VALUES(1, 2);
 } {}
 
 
 # EVIDENCE-OF: R-09681-58560 The table-name specified as part of a
 # DELETE statement within a trigger body must be unqualified.
 #
-# EVIDENCE-OF: R-36771-43788 In other words, the database-name. prefix
-# on the table name is not allowed within triggers.
+# EVIDENCE-OF: R-12275-20298 In other words, the schema-name. prefix on
+# the table name is not allowed within triggers.
 #
 do_delete_tests e_delete-2.1 -error {
   qualified table names are not allowed on INSERT, UPDATE, and DELETE statements within triggers
 } {
   1 {
       CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
         DELETE FROM main.t2;
       END;
   } {}
 
@@ skipping 333 matching lines @@
 } {
   1   "DELETE FROM t1 ORDER BY a DESC LIMIT 2"   {4 5}
   2   "DELETE FROM t1 ORDER BY a DESC LIMIT -1"  {1 2 3 4 5}
   3   "DELETE FROM t1 ORDER BY a ASC LIMIT 2"    {1 2}
   4   "DELETE FROM t1 ORDER BY a ASC LIMIT -1"   {1 2 3 4 5}
 }
 
 }
  
 finish_test