[ https://issues.apache.org/jira/browse/IGNITE-15109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17418144#comment-17418144 ]
Aleksey Plekhanov commented on IGNITE-15109: -------------------------------------------- [~zstan] thanks for the review! Merged to sql-calcite branch. > Calcite engine. TIMESTAMPDIFF for MICROSECOND unit doesn't work > --------------------------------------------------------------- > > Key: IGNITE-15109 > URL: https://issues.apache.org/jira/browse/IGNITE-15109 > Project: Ignite > Issue Type: Bug > Components: sql > Reporter: Yury Gerzhedovich > Assignee: Aleksey Plekhanov > Priority: Major > Labels: calcite2-required, calcite3-required > Time Spent: 10m > Remaining Estimate: 0h > > The function TIMESTAMPDIFF for MICROSECOND unit return incorrect results for > many cases. As the example below returns 0. > {code:sql} > SELECT TIMESTAMPDIFF(MICROSECOND, TIMESTAMP '2022-02-01 10:30:28.000', > TIMESTAMP '2022-02-01 10:30:28.128'){code} > see src/test/sql/function/timestamp/test_timestampdiff.test_ignore -- This message was sent by Atlassian Jira (v8.3.4#803005)