[ https://issues.apache.org/jira/browse/PHOENIX-787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14506353#comment-14506353 ]
Naveen Madhire commented on PHOENIX-787: ---------------------------------------- [~samarthjain] I tested this one and both ROUND and CEIL is returning 1000. I am working on the REPEAT function now, will get to this once I am done there. Thanks. > CEIL function may produce incorrect results for TIMESTAMP > --------------------------------------------------------- > > Key: PHOENIX-787 > URL: https://issues.apache.org/jira/browse/PHOENIX-787 > Project: Phoenix > Issue Type: Task > Affects Versions: 3.0-Release > Reporter: James Taylor > Labels: Newbie > > In the CEIL function, we only consider nanos when the time unit of > MILLISECONDS is used. However, we should consider it for other time units as > well. For example, if the time unit is SECONDS and the TIMESTAMP value > happens to be at an exact multiple of 1000 milliseconds, then the CEIL should > round up, as their will be nano seconds remaining and thus the TIMESTAMP > should be rounded up to the next increment. -- This message was sent by Atlassian JIRA (v6.3.4#6332)