[IGNITE-14963] Calcite engine. Date interval arythmetic returns invalid results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Taras Ledkov
• Created: 22/Jun/21 15:23
• Updated: 17/Mar/22 07:41
• Resolved: 31/Aug/21 14:03

Description

select date '1992-01-01' + interval (17) days - returns 1992-01-18 - valid
select date '1992-01-01' + interval (18) days - returns 1992-01-18 - invalid

Tests:
function/date/test_extract_month.test

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities
• links to: GitHub Pull Request #9286