[
https://issues.apache.org/jira/browse/TAJO-1419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14375357#comment-14375357
]
ASF GitHub Bot commented on TAJO-1419:
--------------------------------------
GitHub user charsyam opened a pull request:
https://github.com/apache/tajo/pull/452
TAJO-1419: Tsql session command doesn't work
This has some problems.
1] case sensitive.
-> Tajo Session Vars distinguish session key name.
-> so "\set timezone GMT+1" is not valid command
-> "\set TIMEZONE GMT+1" is valid.
2] client side var
-> currently client side vars are stored in TajoCliContext with set command
-> but ResultSet just using client session information that are stored in
Server Session.
-> and "SET TIME ZONE 'GMT+1'" command save TIMEZONE Setting as Server
Session.
so If timezone value is stored in client side, it is strange.
so, I changed TIMEZONE from CLISIDE_VAR to SERVER_VAR.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/charsyam/tajo feature/TAJO-1419
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/452.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #452
----
commit 22750cdcc11c42f7117b543a2933477d0e9be63d
Author: clark.kang <[email protected]>
Date: 2015-03-23T03:41:18Z
fix TAJO-1419
----
> Tsql session command doesn't work
> ---------------------------------
>
> Key: TAJO-1419
> URL: https://issues.apache.org/jira/browse/TAJO-1419
> Project: Tajo
> Issue Type: Bug
> Components: cli
> Reporter: Jihoon Son
> Assignee: DaeMyung Kang
> Fix For: 0.10.1
>
>
> See the title.
> You can reproduce the bug as follows:
> {noformat}
> default> select current_date, current_time();
> ?current_date, ?current_time_1
> -------------------------------
> 2015-03-19, 14:55:39.533999
> (1 rows, 0.043 sec, 0 B selected)
> default>
> default> \set timezone GMT+1
> default> select current_date, current_time();
> ?current_date, ?current_time_1
> -------------------------------
> 2015-03-19, 14:55:55.532
> (1 rows, 0.005 sec, 0 B selected)
> default>
> default> SET TIME ZONE 'GMT+1';
> OK
> default> select current_date, current_time();
> ?current_date, ?current_time_1
> -------------------------------
> 2015-03-19, 06:56:33.213
> (1 rows, 0.005 sec, 0 B selected)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
