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

["Paul Guo (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-1092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Guo closed HAWQ-1092.
--------------------------
       Resolution: Fixed
         Assignee: Paul Guo  (was: Lei Chang)
    Fix Version/s: 2.0.1.0-incubating

> lc_collate and lc_ctype do not work after setting through hawq init
> -------------------------------------------------------------------
>
>                 Key: HAWQ-1092
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1092
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Catalog, Command Line Tools
>            Reporter: Paul Guo
>            Assignee: Paul Guo
>             Fix For: 2.0.1.0-incubating
>
>
> Users reports this issue to us, to reproduce:
> {noformat}
> # 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)
> {noformat}
> Besides, the sorting result is also not correct in some cases.
> {noformat}
> # 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)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)