You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2021/09/21 14:15:00 UTC
[jira] [Updated] (IGNITE-15109) Calcite engine. TIMESTAMPDIFF for
MICROSECOND unit doesn't work
[ https://issues.apache.org/jira/browse/IGNITE-15109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Plekhanov updated IGNITE-15109:
---------------------------------------
Labels: calcite3-required (was: calcite2-required calcite3-required)
> 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: 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)