Import SQLite 3.10.2.

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 334 matching lines @@
     SELECT * FROM collate4t2, collate4t1 WHERE a = b;
   }
 } {A a A A 19}
 do_test collate4-2.1.2 {
   execsql {
     CREATE INDEX collate4i1 ON collate4t1(a);
   }
   count {
     SELECT * FROM collate4t2, collate4t1 WHERE a = b;
   }
-} {A a A A 5}
+} {A a A A 4}
 do_test collate4-2.1.3 {
   count {
     SELECT * FROM collate4t2, collate4t1 WHERE b = a;
   }
 } {A A 19}
 do_test collate4-2.1.4 {
   execsql {
     DROP INDEX collate4i1;
     CREATE INDEX collate4i1 ON collate4t1(a COLLATE TEXT);
   }
   count {
     SELECT * FROM collate4t2, collate4t1 WHERE a = b
      ORDER BY collate4t2.rowid, collate4t1.rowid
   }
 } {A a A A 19}
 do_test collate4-2.1.5 {
   count {
     SELECT * FROM collate4t2, collate4t1 WHERE b = a;
   }
-} {A A 4}
+} {A A 3}
 ifcapable subquery {
   do_test collate4-2.1.6 {
     count {
       SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2)
        ORDER BY rowid
     }
   } {a A 10}
   do_test collate4-2.1.7 {
     execsql {
       DROP INDEX collate4i1;
       CREATE INDEX collate4i1 ON collate4t1(a);
     }
     count {
       SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2)
        ORDER BY rowid
     }
-  } {a A 6}
+  } {a A 5}
   do_test collate4-2.1.8 {
     count {
       SELECT a FROM collate4t1 WHERE a IN ('z', 'a');
     }
-  } {a A 5}
+  } {a A 4}
   do_test collate4-2.1.9 {
     execsql {
       DROP INDEX collate4i1;
       CREATE INDEX collate4i1 ON collate4t1(a COLLATE TEXT);
     }
     count {
       SELECT a FROM collate4t1 WHERE a IN ('z', 'a') ORDER BY rowid;
     }
   } {a A 9}
 }
@@ skipping 287 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