Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hawq.incubator.apache.org
Date: Sun, 9 Oct 2016 10:00:27 +0000 (UTC)
From: "Paul Guo (JIRA)" <jira@apache.org>
To: dev@hawq.incubator.apache.org
Message-ID: <JIRA.13010813.1476007162000.776514.1476007227371@Atlassian.JIRA>
In-Reply-To: <JIRA.13010813.1476007162000@Atlassian.JIRA>
References: <JIRA.13010813.1476007162000@Atlassian.JIRA> <JIRA.13010813.1476007162036@arcas>
Subject: [jira] [Created] (HAWQ-1092) Setting lc_collate and lc_ctype
 through hawq init does not work.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Sun, 09 Oct 2016 10:00:32 -0000

Paul Guo created HAWQ-1092:
------------------------------

             Summary: Setting lc_collate and lc_ctype through hawq init doe=
s not work.
                 Key: HAWQ-1092
                 URL: https://issues.apache.org/jira/browse/HAWQ-1092
             Project: Apache HAWQ
          Issue Type: Bug
            Reporter: Paul Guo
            Assignee: Lei Chang


Users reports this issue to us, to reproduce:

# hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-cty=
pe ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeri=
c 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, '=E3=82=A6');
INSERT INTO t VALUES (2, '=E3=83=81');
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 | =E3=82=A6
  2 | =E3=83=81
  3 | abd
  4 | DEF
  5 | ghi
(5 rows)


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