[
https://issues.apache.org/jira/browse/TAJO-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-763:
------------------------------
Affects Version/s: 0.8
Fix Version/s: 0.8
> 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)
