[HAWQ-1092] lc_collate and lc_ctype do not work after setting through hawq init

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0.0-incubating
• Component/s: Catalog, Command Line Tools
• Assignee: Paul Guo
• Reporter: Paul Guo
• Created: 09/Oct/16 09:59
• Updated: 18/Feb/17 05:27
• Resolved: 22/Dec/16 06:47

Description

Users reports this issue to us, to reproduce:

# hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric ja_JP.utf8 --lc-time ja_JP.utf8

#psql -d postgres -c "SELECT name, setting from pg_settings where name like 'lc%'"
    name     |  setting
-------------+------------
 lc_collate  | C
 lc_ctype    | C
 lc_messages | ja_JP.utf8
 lc_monetary | ja_JP.utf8
 lc_numeric  | ja_JP.utf8
 lc_time     | ja_JP.utf8
(6 rows)

Besides, the sorting result is also not correct in some cases.

# cat sort2.sql
DROP TABLE IF EXISTS t;
CREATE TABLE t (id INT, name TEXT);

INSERT INTO t VALUES (1, 'ウ');
INSERT INTO t VALUES (2, 'チ');
INSERT INTO t VALUES (3, 'abd');
INSERT INTO t VALUES (4, 'DEF');
INSERT INTO t VALUES (5, 'ghi');

SELECT * FROM t ORDER BY name;

#  psql postgres -f sort2.sql
........
 id | name
----+------
  1 | ウ
  2 | チ
  3 | abd
  4 | DEF
  5 | ghi
(5 rows)

Issue Links

• links to: GitHub Pull Request #953