[
https://issues.apache.org/jira/browse/TAJO-1961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jihoon Son updated TAJO-1961:
-----------------------------
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:
{noformat}
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)
{noformat}
was:
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:
{noformat}
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 timezone 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)
{noformat}
> Client timezone does not work properly
> --------------------------------------
>
> Key: TAJO-1961
> URL: https://issues.apache.org/jira/browse/TAJO-1961
> Project: Tajo
> Issue Type: Bug
> Components: Client
> Reporter: Jihoon Son
> Fix For: 0.12.0, 0.11.1
>
>
> 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:
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
