Import SQLite 3.7.6.3.

third_party/sqlite/src/test/select6.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 440 matching lines @@
     WHERE e.r=f.z
   }
 } {1}
 } ;# ifcapable view
 
 # Ticket #1634
 #
 do_test select6-9.1 {
   execsql {
     SELECT a.x, b.x FROM t1 AS a, (SELECT x FROM t1 LIMIT 2) AS b
+     ORDER BY 1, 2
   }
 } {1 1 1 2 2 1 2 2 3 1 3 2 4 1 4 2}
 do_test select6-9.2 {
   execsql {
     SELECT x FROM (SELECT x FROM t1 LIMIT 2);
   }
 } {1 2}
 do_test select6-9.3 {
   execsql {
     SELECT x FROM (SELECT x FROM t1 LIMIT 2 OFFSET 1);
@@ skipping 36 matching lines @@
 } {2 12 3 13 4 14}
 do_test select6-9.11 {
   execsql {
     SELECT x, y FROM (SELECT x, (SELECT 10)+x y FROM t1 LIMIT -1 OFFSET 1);
   }
 } {2 12 3 13 4 14}
 
 
 
 finish_test