Import SQLite 3.7.6.3.

third_party/sqlite/src/test/collate4.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 303 matching lines @@
 #
 # These tests - collate4-2.* - check that indices are correctly
 # selected or not selected to implement WHERE clauses when user 
 # defined collation sequences are involved. 
 #
 # Indices may optimise WHERE clauses using <, >, <=, >=, = or IN
 # operators.
 #
 do_test collate4-2.1.0 {
   execsql {
+    PRAGMA automatic_index=OFF;
     CREATE TABLE collate4t1(a COLLATE NOCASE);
     CREATE TABLE collate4t2(b COLLATE TEXT);
 
     INSERT INTO collate4t1 VALUES('a');
     INSERT INTO collate4t1 VALUES('A');
     INSERT INTO collate4t1 VALUES('b');
     INSERT INTO collate4t1 VALUES('B');
     INSERT INTO collate4t1 VALUES('c');
     INSERT INTO collate4t1 VALUES('C');
     INSERT INTO collate4t1 VALUES('d');
@@ skipping 85 matching lines @@
     INSERT INTO collate4t1 VALUES('0', '1', '1');
     INSERT INTO collate4t1 VALUES('1', '0', '0');
     INSERT INTO collate4t1 VALUES('1', '0', '1');
     INSERT INTO collate4t1 VALUES('1', '1', '0');
     INSERT INTO collate4t1 VALUES('1', '1', '1');
     insert into collate4t2 SELECT * FROM collate4t1;
   }
 } {}
 do_test collate4-2.2.1 {
   count {
-    SELECT * FROM collate4t2 NATURAL JOIN collate4t1;
+    SELECT * FROM collate4t2 NOT INDEXED NATURAL JOIN collate4t1 NOT INDEXED;
   }
 } {0 0 0 0 0 1 0 1 0 0 1 1 1 0 0 1 0 1 1 1 0 1 1 1 63}
 do_test collate4-2.2.1b {
   execsql {
     CREATE INDEX collate4i1 ON collate4t1(a, b, c);
   }
   count {
     SELECT * FROM collate4t2 NATURAL JOIN collate4t1;
   }
 } {0 0 0 0 0 1 0 1 0 0 1 1 1 0 0 1 0 1 1 1 0 1 1 1 29}
@@ skipping 251 matching lines @@
     SELECT * FROM collate4t1 ORDER BY oid;
   }
 } {10 15 101 nosort}
 do_test collate4-6.3 {
   cksort {
     SELECT * FROM collate4t1 ORDER BY oid||'' COLLATE TEXT;
   }
 } {10 101 15 sort}
 
 finish_test