[TAJO-1961] Client timezone does not work properly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.12.0, 0.11.1
• Component/s: Client
• Assignee: DaeMyung Kang
• Reporter: Jihoon Son
• Created: 05/Nov/15 05:36
• Updated: 15/Dec/15 05:16
• Resolved: 15/Dec/15 05:16

Description

There are two problems.

• \set command does not work.
• Client timezone does not work when any timezone is configured for input table.

You can reproduce as follows:

default> create table test (col time);
OK
default> insert into test select current_time();
OK
default> select * from test;
col
-------------------------------
05:32:54.161999
(1 rows, 0.018 sec, 0 B selected)
default> set time zone 'GMT+9'
default> select * from test;
col
-------------------------------
05:32:54.161999
(1 rows, 0.019 sec, 0 B selected)
default> create table test2 (col time) with ('timezone'='ASIA/Seoul');
OK
default> insert into test2 select current_time();
OK
default> select * from test2;
col
-------------------------------
14:22:52.747999
(1 rows, 0.02 sec, 0 B selected)
default> \set timezone GMT-3
default> select * from test2;
col
-------------------------------
14:22:52.747999
(1 rows, 0.018 sec, 0 B selected)
default> set time zone 'GMT-3';
OK
default> select * from test2;
col
-------------------------------
02:22:52.747999
(1 rows, 0.021 sec, 0 B selected)
default> \set timezone GMT+9
default> select * from test2;
col
-------------------------------
02:22:52.747999
(1 rows, 0.018 sec, 0 B selected)