PG_Exp_2.sql

application/octet-stream

Filename: PG_Exp_2.sql

Type: application/octet-stream

Part: 1

Message: Problem in 'ORDER BY' of a column using a created collation?

CREATE TABLE test_table (value1 varchar, value2 varchar);

INSERT INTO test_table VALUES ('1', '1');
INSERT INTO test_table VALUES ('1', 'a');
INSERT INTO test_table VALUES ('1', '2');
INSERT INTO test_table VALUES ('1', 'b');
INSERT INTO test_table VALUES ('2', '1');
INSERT INTO test_table VALUES ('2', 'a');
INSERT INTO test_table VALUES ('2', '2');
INSERT INTO test_table VALUES ('2', 'b');
INSERT INTO test_table VALUES ('a', '1');
INSERT INTO test_table VALUES ('a', 'a');
INSERT INTO test_table VALUES ('a', 'b');
INSERT INTO test_table VALUES ('a', '2');
INSERT INTO test_table VALUES ('b', '1');
INSERT INTO test_table VALUES ('b', 'a');
INSERT INTO test_table VALUES ('b', '2');
INSERT INTO test_table VALUES ('b', 'b');

CREATE COLLATION test_coll (provider = icu, locale = 'ja-u-kr-digit-latn');

SELECT * FROM test_table ORDER BY value1 COLLATE test_coll, value2 COLLATE test_coll;
SELECT * FROM test_table ORDER BY value2 COLLATE test_coll, value1 COLLATE test_coll;

DROP TABLE test_table;
DROP COLLATION test_coll;