[IGNITE-14961] Calcite engine. Arithmetic operators cannot be applied to <DATE> + <INTEGER>

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: uncertain
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Taras Ledkov
• Created: 22/Jun/21 11:32
• Updated: 24/May/22 11:50

Description

The query
SELECT CAST('2000-10-10' AS DATE) + 2
fails with SqlValidatorException

Cannot apply '+' to arguments of type '<DATE> + <INTEGER>'. Supported form(s): '<NUMERIC> + <NUMERIC>'
'<DATETIME_INTERVAL> + <DATETIME_INTERVAL>'
'<DATETIME> + <DATETIME_INTERVAL>'
'<DATETIME_INTERVAL> + <DATETIME>'

Tests:
function/date/test_extract_edge_cases.test_ignore

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities