[
https://issues.apache.org/jira/browse/TAJO-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13974731#comment-13974731
]
Hudson commented on TAJO-763:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #186 (See
[https://builds.apache.org/job/Tajo-master-build/186/])
TAJO-763: Out of range problem in utc_usec_to() (modified contributor name to
Ilhyun Suh in CHANGES.txt). (hyunsik: rev
6a005ce7e4c5ed80278da702255197936c189ff3)
* CHANGES.txt
> Out of range problem in utc_usec_to()
> -------------------------------------
>
> Key: TAJO-763
> URL: https://issues.apache.org/jira/browse/TAJO-763
> Project: Tajo
> Issue Type: Bug
> Components: function/udf
> Affects Versions: 0.8, 0.9
> Reporter: Jihoon Son
> Assignee: Ilhyun Suh
> Priority: Minor
> Fix For: 0.8, 0.9
>
> Attachments: TAJO-763.patch
>
>
> When I run the following query using the utc_usec_to function, I met an out
> of range error.
> Since this problem occurs only when converting to hour, it seems to relate
> with the time zone.
> {noformat}
> default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05
> 08:00:00')::INT8*1000);
> result: 1 rows (9 B)
> ?utc_usec_to
> -------------------------------
> 1365116400000000
> default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05
> 09:00:00')::INT8*1000);
> Value 24 for hourOfDay must be in the range [0,23]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
