[IGNITE-18752] Sql. Bump calcite version to 1.34.0

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 08/Feb/23 06:03
• Updated: 04/Sep/23 12:19
• Resolved: 31/Mar/23 12:56

Description

New ver of apache calcite is available [1], ARG_MIN and ARG_MAX are appended [2] probably we need to check it on ignite side. Also we need to remove mention of CALCITE-5253 from code and fix a tests (for ai-3 only) and CALCITE-5297 (for probably both)

[1] https://calcite.apache.org/docs/history.html#v1-34-0
[2] https://issues.apache.org/jira/browse/CALCITE-5283

Known problems:

• In calcite 1.33.0 date functions such as LAST_DAY were moved from SqlFunctions to RexImpTable.
• ignite 3 implementation of TIMESTAMPDIFF function is no longer works - https://issues.apache.org/jira/browse/IGNITE-18817

Issue Links

• blocks: IGNITE-18798 Sql. Custom types. UUID literal.
• is blocked by: CALCITE-5531 COALESCE throws ClassCastException
• is related to: IGNITE-20341 SQL Calcite. Bump calcite version to 1.34
• links to: GitHub Pull Request #1847
• links to: GitHub Pull Request #1847