[IGNITE-15555] Calcite engine. Operator MINUS_DATE for days, hours, and minutes returns wrong result

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 22/Sep/21 08:34
• Updated: 28/Feb/22 13:11
• Resolved: 29/Oct/21 10:36

Description

For example, all queries:

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

Returns 86400000 (the value in milliseconds)

For YEAR time unit return the same value as for MONTH.

Issue Links

• is fixed by: IGNITE-14975 Calcite engine. Introduce suppot INTERVAL type.
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• is related to: IGNITE-14975 Calcite engine. Introduce suppot INTERVAL type.