Import SQLite 3.8.7.4.

third_party/sqlite/src/test/eval.test

 # 2008 July 11
 #
 # 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 40 matching lines @@
     CREATE TABLE t2(x,y);
     INSERT INTO t2 SELECT x, x+1 FROM t1 WHERE x<5;
     SELECT x, test_eval('DELETE FROM t2 WHERE x='||x), y FROM t2;
   }
 } {1 {} {} 2 {} {} 3 {} {} 4 {} {}}
 do_test eval-2.2 {
   execsql {
     SELECT * FROM t2
   }
 } {}
+do_test eval-2.3 {
+  execsql {
+    INSERT INTO t2 SELECT x, x+1 FROM t1 WHERE x<5;
+    SELECT x, test_eval('DELETE FROM t2 WHERE x='||x), y FROM t2
+     ORDER BY rowid DESC;
+  }
+} {4 {} {} 3 {} {} 2 {} {} 1 {} {}}
+do_test eval-2.4 {
+  execsql {
+    SELECT * FROM t2
+  }
+} {}
 
 # Modify a row while it is being read.
 #
 do_test eval-3.1 {
   execsql {
     INSERT INTO t2 SELECT x, x+1 FROM t1 WHERE x<5;
     SELECT x, test_eval('UPDATE t2 SET y=y+100 WHERE x='||x), y FROM t2;
   }
 } {1 {} 102 2 {} 103 3 {} 104 4 {} 105}
 
 do_test eval-4.1 {
   execsql { SELECT test_eval('SELECT "abcdefghij"') }
 } {abcdefghij}
 
 finish_test