Aleksey Plekhanov created IGNITE-15555: ------------------------------------------
Summary: 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 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{noformat} Returns {{86400000}} (the same value as for {{SECONDS}}) But this operator works correctly with MONTHS and SECONDS time units. -- This message was sent by Atlassian Jira (v8.3.4#803005)