[ https://issues.apache.org/jira/browse/IGNITE-15555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Evgeny Stanilovsky updated IGNITE-15555: ---------------------------------------- Labels: calcite (was: calcite calcite3-required ignite-3) > Calcite engine. Operator MINUS_DATE for days, hours, and minutes returns > wrong result > ------------------------------------------------------------------------------------- > > Key: IGNITE-15555 > URL: https://issues.apache.org/jira/browse/IGNITE-15555 > Project: Ignite > Issue Type: Bug > Reporter: Aleksey Plekhanov > Assignee: Aleksey Plekhanov > Priority: Major > Labels: calcite > > For example, all queries: > {noformat} > SELECT (DATE '2021-01-02' - DATE '2021-01-01') DAYS > SELECT (DATE '2021-01-02' - DATE '2021-01-01') HOURS > SELECT (DATE '2021-01-02' - DATE '2021-01-01') MINUTES > SELECT (DATE '2021-01-02' - DATE '2021-01-01') SECONDS{noformat} > Returns {{86400000}} (the value in milliseconds) > For YEAR time unit return the same value as for MONTH. -- This message was sent by Atlassian Jira (v8.20.1#820001)