Index: test/collate5.test
==================================================================
--- test/collate5.test
+++ test/collate5.test
@@ -12,11 +12,11 @@
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing DISTINCT, UNION, INTERSECT and EXCEPT
 # SELECT statements that use user-defined collation sequences. Also
 # GROUP BY clauses that use user-defined collation sequences.
 #
-# $Id: collate5.test,v 1.6 2007/11/12 15:29:19 danielk1977 Exp $
+# $Id: collate5.test,v 1.7 2008/09/16 11:58:20 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 
 
@@ -67,10 +67,32 @@
   execsql {
     SELECT DISTINCT a, b FROM collate5t1;
   }
 } {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;
+  }
+} {abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789ABXYZ012234567890123456789}
+do_test collate5-1.12 {
+  sqlite3 db2 :memory:
+  db2 eval {
+    PRAGMA encoding=UTF16le;
+    CREATE TABLE tkt3376(a COLLATE nocase PRIMARY KEY);
+    INSERT INTO tkt3376 VALUES('abc');
+    INSERT INTO tkt3376 VALUES('ABX');
+    SELECT DISTINCT a FROM tkt3376;
+  }
+} {abc ABX}
+catch {db2 close}
+
 # The remainder of this file tests compound SELECT statements.
 # Omit it if the library is compiled such that they are omitted.
 #
 ifcapable !compound {
   finish_test