Github user jihoonson commented on the pull request:
https://github.com/apache/tajo/pull/993#issuecomment-212225990
@jinossy, thanks for your quick response. I agree on the need of parser
validator.
In addition to the above comments, I found another case in which the result
is not the one I expected.
Here is an example.
```
default> create table test2 (ts timestamp, d date, t time) with
('timezone'='GMT-5');
OK
default> \d test2
table name: default.test2
table uri: hdfs://localhost:7020/tajo/warehouse/default/test2
store type: TEXT
number of rows: 0
volume: 0 B
Options:
'timezone'='GMT-5'
'text.delimiter'='|'
schema:
ts TIMESTAMP
d DATE
t TIME
default> insert into test2 select '2016-05-01 02:02:33'::timestamp,
'2016-05-01':: date, '02:02:33'::time;
OK
default> \set
Invalid command \se. Try \? for help.
'SESSION_LAST_ACCESS_TIME'='1461120772913'
'CURRENT_DATABASE'='default'
'USERNAME'='jihoon'
'SESSION_ID'='351f5cb9-7dea-4277-9041-46962439622e'
'TIMEZONE'='Asia/Seoul'
'FETCH_ROWNUM'='200'
'COMPRESSED_RESULT_TRANSFER'='false'
default> select * from test2;
ts, d, t
-------------------------------
2016-05-01 02:02:33, 2016-05-01, 02:02:33
(1 rows, 0.028 sec, 0 B selected)
default> \set TIMEZONE GMT-5
default> select * from test2;
ts, d, t
-------------------------------
2016-04-30 12:02:33, 2016-05-01, 02:02:33
(1 rows, 0.014 sec, 0 B selected)
```
Even though I created the table ```test2``` with the timezone of 'GMT-5',
the result value is the inserted one only when the client timezone is 'GMT+9'.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
