Import SQLite 3.8.7.4.

third_party/sqlite/src/test/collate5.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 39 matching lines @@
     INSERT INTO collate5t1 VALUES('b', 'banana');
     INSERT INTO collate5t1 VALUES('B', 'banana');
     INSERT INTO collate5t1 VALUES('n', NULL);
     INSERT INTO collate5t1 VALUES('N', NULL);
   } 
 } {}
 do_test collate5-1.1 {
   execsql {
     SELECT DISTINCT a FROM collate5t1;
   }
-} {A B N}
+} {a b n}
 do_test collate5-1.2 {
   execsql {
     SELECT DISTINCT b FROM collate5t1;
   }
-} {{} Apple apple banana}
+} {apple Apple banana {}}
 do_test collate5-1.3 {
   execsql {
     SELECT DISTINCT a, b FROM collate5t1;
   }
-} {A Apple a apple B banana N {}}
+} {a apple A Apple b banana n {}}
 
 # Ticket #3376
 #
 do_test collate5-1.11 {
   execsql {
     CREATE TABLE tkt3376(a COLLATE nocase PRIMARY KEY);
     INSERT INTO tkt3376 VALUES('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz');
     INSERT INTO tkt3376 VALUES('ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789');
     SELECT DISTINCT a FROM tkt3376;
   }
@@ skipping 133 matching lines @@
 unset ::lens
 
 #
 # These tests - collate5-3.* - focus on compound SELECT queries that 
 # feature ORDER BY clauses.
 #
 do_test collate5-3.0 {
   execsql {
     SELECT a FROM collate5t1 UNION ALL SELECT a FROM collate5t2 ORDER BY 1;
   }
-} {a A a A b B b B n N}
+} {/[aA] [aA] [aA] [aA] [bB] [bB] [bB] [bB] [nN] [nN]/}
 do_test collate5-3.1 {
   execsql {
     SELECT a FROM collate5t2 UNION ALL SELECT a FROM collate5t1 ORDER BY 1;
   }
 } {A A B B N a a b b n}
 do_test collate5-3.2 {
   execsql {
     SELECT a FROM collate5t1 UNION ALL SELECT a FROM collate5t2 
       ORDER BY 1 COLLATE TEXT;
   }
@@ skipping 40 matching lines @@
 } {}
 do_test collate5-4.1 {
   string tolower [execsql {
     SELECT a, count(*) FROM collate5t1 GROUP BY a;
   }]
 } {a 2 b 2}
 do_test collate5-4.2 {
   execsql {
     SELECT a, b, count(*) FROM collate5t1 GROUP BY a, b ORDER BY a, b;
   }
-} {A 1.0 2 b 2 1 B 3 1}
+} {/[aA] 1(.0)? 2 [bB] 2 1 [bB] 3 1/}
 do_test collate5-4.3 {
   execsql {
     DROP TABLE collate5t1;
   }
 } {}
 
 finish_test