#458 COLLATE clause causes incorrect sort results.

[cbx]

I observed wrong sorted results on a SELECT query with COLLATE clause.

test=# SELECT * FROM FOOBAR ORDER BY all_alpha COLLATE "en_US";
 all_alpha 
-----------
 A
 b
 B
 z
 Z
 a
(6 rows)

You can reproduce by following instructions.

• Create a database with ja_JP.UTF-8 locale on XC cluster which consist of 2Co2Dn.

• Execute following queries.

  • CREATE TABLE Foobar (all_alpha VARCHAR(6));

  • INSERT INTO Foobar VALUES('a');

  • INSERT INTO Foobar VALUES('A');
  • INSERT INTO Foobar VALUES('b');
  • INSERT INTO Foobar VALUES('B');
  • INSERT INTO Foobar VALUES('z');

  • INSERT INTO Foobar VALUES('Z');

  • SELECT * FROM FOOBAR ORDER BY all_alpha COLLATE "en_US";

[cbx]

• Description has changed:

Diff:

--- old
+++ new
@@ -19,9 +19,9 @@

     * INSERT INTO Foobar VALUES('a');
     * INSERT INTO Foobar VALUES('A');
-    INSERT INTO Foobar VALUES('b');
-    INSERT INTO Foobar VALUES('B');
-    INSERT INTO Foobar VALUES('z');
-    INSERT INTO Foobar VALUES('Z');
+    * INSERT INTO Foobar VALUES('b');
+    * INSERT INTO Foobar VALUES('B');
+    * INSERT INTO Foobar VALUES('z');
+    * INSERT INTO Foobar VALUES('Z');

-    SELECT * FROM FOOBAR ORDER BY all_alpha COLLATE "en_US";
+    * SELECT * FROM FOOBAR ORDER BY all_alpha COLLATE "en_US";