[Postgres-xc-developers] COLLATE clause causes incorrect sort results

[Masataka S. <pg...@gm...>]

Hi, all.

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)

Related ticket is here.
https://sourceforge.net/p/postgres-xc/bugs/458/

Please refer the ticket for more details including instructions to reproduce.

Regards.