Import SQLite 3.7.6.3.

third_party/sqlite/src/test/select2.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 135 matching lines @@
     INSERT INTO aa VALUES(1);
     INSERT INTO aa VALUES(3);
     INSERT INTO bb VALUES(2);
     INSERT INTO bb VALUES(4);
     SELECT * FROM aa, bb WHERE max(a,b)>2;
   }
 } {1 4 3 2 3 4}
 do_test select2-4.2 {
   execsql {
     INSERT INTO bb VALUES(0);
-    SELECT * FROM aa, bb WHERE b;
+    SELECT * FROM aa CROSS JOIN bb WHERE b;
   }
 } {1 2 1 4 3 2 3 4}
 do_test select2-4.3 {
   execsql {
-    SELECT * FROM aa, bb WHERE NOT b;
+    SELECT * FROM aa CROSS JOIN bb WHERE NOT b;
   }
 } {1 0 3 0}
 do_test select2-4.4 {
   execsql {
     SELECT * FROM aa, bb WHERE min(a,b);
   }
 } {1 2 1 4 3 2 3 4}
 do_test select2-4.5 {
   execsql {
     SELECT * FROM aa, bb WHERE NOT min(a,b);
   }
 } {1 0 3 0}
 do_test select2-4.6 {
   execsql {
     SELECT * FROM aa, bb WHERE CASE WHEN a=b-1 THEN 1 END;
   }
 } {1 2 3 4}
 do_test select2-4.7 {
   execsql {
     SELECT * FROM aa, bb WHERE CASE WHEN a=b-1 THEN 0 ELSE 1 END;
   }
 } {1 4 1 0 3 2 3 0}
 
 finish_test