Import SQLite 3.10.2.

third_party/sqlite/src/test/delete.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.
 #
 #***********************************************************************
@@ skipping 50 matching lines @@
   execsql {DELETE FROM table1 WHERE f1=2}
 } {1}
 do_test delete-3.1.6.2 {
   db changes
 } 1
 do_test delete-3.1.7 {
   execsql {SELECT * FROM table1 ORDER BY f1}
 } {1 2 4 16}
 integrity_check delete-3.2
 
-
 # Semantic errors in the WHERE clause
 #
 do_test delete-4.1 {
   execsql {CREATE TABLE table2(f1 int, f2 int)}
   set v [catch {execsql {DELETE FROM table2 WHERE f3=5}} msg]
   lappend v $msg
 } {1 {no such column: f3}}
 
 do_test delete-4.2 {
   set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
@@ skipping 303 matching lines @@
   set res [list]
   db eval { SELECT t5.rowid AS r, c, d FROM t5, t6 ORDER BY a } {
     if {$r==2} { db eval { DELETE FROM t5 WHERE rowid = 3 } }
     lappend res $r $c $d
   }
   set res
 } {1 a b 1 c d 2 a b 2 c d}
 
 
 finish_test