[
https://issues.apache.org/jira/browse/TAJO-1366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14344461#comment-14344461
]
ASF GitHub Bot commented on TAJO-1366:
--------------------------------------
GitHub user jihoonson opened a pull request:
https://github.com/apache/tajo/pull/395
TAJO-1366: The timestamp type conversion occasionally leads to wrong results
Let me suppose an example query as follows:
```
select 'Mon Nov 03 00:03:00 +0000 2014'::timestamp;
```
The problem is that 'Mon' is identified as the ```UNITS``` type, but its
actual type is ```DOW``` in this query.
This wrong parsing result is led by the duplicated key when managing
DateTimeConstants in a map.
So, I removed all items of ```deltatktbl```, which causes the duplication
problem, from the constants map.
This table is used when parsing ```interval```, but we don't support it yet.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/jihoonson/tajo-2 TAJO-1366
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/395.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 #395
----
commit baed07522caca353a231564861306790385673ea
Author: Jihoon Son <[email protected]>
Date: 2015-03-03T03:32:29Z
TAJO-1366
commit fd783f0842d2bf41dbad4e218bf6c53b85d0c9dc
Author: Jihoon Son <[email protected]>
Date: 2015-03-03T03:33:40Z
TAJO-1366
----
> The timestamp type conversion occasionally leads to wrong results
> -----------------------------------------------------------------
>
> Key: TAJO-1366
> URL: https://issues.apache.org/jira/browse/TAJO-1366
> Project: Tajo
> Issue Type: Bug
> Reporter: Jihoon Son
> Assignee: Jihoon Son
>
> See the title.
> Here is an example of the bug.
> {noformat}
> default> select 'Mon Nov 03 00:03:00 +0000 2014'::timestamp;
> ?cast
> -------------------------------
> 0001-10-31 09:03:00 BC
> (1 rows, 0.004 sec, 0 B selected)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
