[
https://issues.apache.org/jira/browse/HAWQ-713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15272617#comment-15272617
]
ASF GitHub Bot commented on HAWQ-713:
-------------------------------------
Github user karthijrk closed the pull request at:
https://github.com/apache/incubator-hawq/pull/635
> lc_numeric guc doesn't behave as expected after some time
> ---------------------------------------------------------
>
> Key: HAWQ-713
> URL: https://issues.apache.org/jira/browse/HAWQ-713
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core
> Reporter: Karthikeyan Jambu Rajaraman
> Assignee: Lei Chang
> Attachments: lc_numeric_check.out, lc_numeric_check.sql
>
>
> Create a simple table with a 1,1 value in it that we will change based on
> lc_numeric. Default we are expecting will be 11 but 1.1 under de_DE
> {code}
> gpadmin=# \d tbl_lc_numeric_test
> Table "public.tbl_lc_numeric_test"
> Column | Type | Modifiers
> --------+-----------------------+-----------
> a | text |
> s | character varying(50) |
> Distributed by: (a)
> gpadmin=# select * from tbl_lc_numeric_test;
> a | s
> -----+-----------
> 3 | blablabla
> 1,1 | bla
> 2 | blabla
> (3 rows)
> {code}
> When lc_numeric is changed 'de_DE.utf8' as shown below, '1,1' is printed as
> '1.1' as expected.
> {code}
> gpadmin=# set lc_numeric='de_DE.utf8';
> SET
> gpadmin=# show lc_numeric
> gpadmin-# ;
> lc_numeric
> ------------
> de_DE.utf8
> (1 row)
> gpadmin=# \echo `date`
> Thu Apr 21 10:05:00 PDT 2016
> gpadmin=# select to_number(a,'999999D99999')::numeric(10,5), s from
> tbl_lc_numeric_test;
> to_number | s
> -----------+-----------
> 1.10000 | bla
> 3.00000 | blablabla
> 2.00000 | blabla
> (3 rows)
> {code}
> But if we run above select again after some time (after idle gang timeout),
> then we saw the value as 11 instead of 1.1.
> {code}
> gpadmin=# \echo `date`
> Thu Apr 21 10:05:30 PDT 2016
> gpadmin=# select to_number(a,'999999D99999')::numeric(10,5), s from
> tbl_lc_numeric_test;
> to_number | s
> -----------+-----------
> 3.00000 | blablabla
> 2.00000 | blabla
> 11.00000 | bla
> (3 rows)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
