Import SQLite 3.10.2.

third_party/sqlite/src/test/collate3.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 14 matching lines @@
 # collate3.4.* - Misc errors.
 # collate3.5.* - Collation factory.
 #
 
 #
 # These tests ensure that when a user executes a statement with an 
 # unknown collation sequence an error is returned.
 #
 do_test collate3-1.0 {
   execsql {
-    CREATE TABLE collate3t1(c1);
+    CREATE TABLE collate3t1(c1 UNIQUE);
   }
 } {}
 do_test collate3-1.1 {
   catchsql {
     SELECT * FROM collate3t1 ORDER BY 1 collate garbage;
   }
 } {1 {no such collation sequence: garbage}}
+do_test collate3-1.1.2 {
+  catchsql {
+    SELECT DISTINCT c1 COLLATE garbage FROM collate3t1;
+  }
+} {1 {no such collation sequence: garbage}}
 do_test collate3-1.2 {
   catchsql {
     CREATE TABLE collate3t2(c1 collate garbage);
   }
 } {1 {no such collation sequence: garbage}}
 do_test collate3-1.3 {
   catchsql {
     CREATE INDEX collate3i1 ON collate3t1(c1 COLLATE garbage);
   }
 } {1 {no such collation sequence: garbage}}
@@ skipping 464 matching lines @@
   }
 } {0 {}}
 
 do_test collate3-5.9 {
   execsql {
     DROP TABLE collate3t1;
   }
 } {}
 
 finish_test