Import SQLite 3.7.6.3.

third_party/sqlite/src/test/misc4.test

 # 2004 Jun 27
 #
 # 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 133 matching lines @@
       insert into a values('01','data01');
       insert into a values('+1','data+1');
       
       insert into b values ('01',1);
       insert into b values ('01',2);
       insert into b values ('+1',3);
       insert into b values ('+1',4);
       
       select a.*, x.*
         from a, (select key,sum(period) from b group by key) as x
-        where a.key=x.key;
+        where a.key=x.key order by 1 desc;
     }
   } {01 data01 01 3 +1 data+1 +1 7}
 
   # This test case tests the same property as misc4-4.1, but it is
   # a bit smaller which makes it easier to work with while debugging.
   do_test misc4-4.2 {
     execsql {
       CREATE TABLE ab(a TEXT, b TEXT);
       INSERT INTO ab VALUES('01', '1');
     }
@@ skipping 37 matching lines @@
     CREATE TABLE def(d, e, f, PRIMARY KEY(d, e));
   }
 } {}
 do_test misc4-6.2 {
   execsql {
     SELECT a FROM abc LEFT JOIN def ON (abc.a=def.d);
   }
 } {1}
 
 finish_test