Import SQLite 3.7.6.3.

third_party/sqlite/src/test/triggerA.test

 # 2008 February 12
 #
 # 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 59 matching lines @@
   db eval {
      CREATE VIEW v4 AS
         SELECT CAST(x AS TEXT) AS c1 FROM t1
         UNION SELECT y FROM t1 WHERE x BETWEEN 3 and 5;
      SELECT * FROM v4 ORDER BY 1;
   }
 } {1 10 2 3 4 5 6 7 8 9 five four three}
 do_test triggerA-1.6 {
   db eval {
      CREATE VIEW v5 AS SELECT x, b FROM t1, t2 WHERE y=c;
-     SELECT * FROM v5;
+     SELECT * FROM v5 ORDER BY x DESC;
   }
 } {10 1003 9 904 8 805 7 705 6 603 5 504 4 404 3 305 2 203 1 103}
 
 # Create INSTEAD OF triggers on the views.  Run UPDATE and DELETE statements
 # using those triggers.  Verify correct operation.
 #
 do_test triggerA-2.1 {
   db eval {
      CREATE TABLE result2(a,b);
      CREATE TRIGGER r1d INSTEAD OF DELETE ON v1 BEGIN
@@ skipping 130 matching lines @@
 } -sqlbody {
    DELETE FROM v5 WHERE x=5;
    UPDATE v5 SET b=b+9900000 WHERE x BETWEEN 3 AND 5;
 }
 
 # Clean up the saved database copy.
 #
 file delete -force test.db-triggerA
 
 finish_test