[IGNITE-17599] Calcite engine. Support LocalDate/LocalTime types

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.14
• Fix Version/s: 2.15
• Labels: calcite ise
• Release Note: SQL Calcite: Added support for LocalDate/LocalTime types
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Ivan Daschinsky
• Reporter: Aleksey Plekhanov
• Created: 30/Aug/22 14:59
• Updated: 20/Apr/23 10:35
• Resolved: 29/Nov/22 18:12

Description

H2-based engine works with LocalData/LocalTime types as java.sql.Data/java.sql.Time types. To check if value with LocalDate type can be inserted to descriptor with type java.sql.Data some logic from IgniteH2Indexing.isConvertibleToColumnType is used. If Calcite engine used without ignite-indexing this logic is unavailable.

We should:

1. Provide an ability to work in Calcite-based engine with LocalDate/LocalTime type in the same way as java.sql.Data/java.sql.Time types.
2. Move IgniteH2Indexing.isConvertibleToColumnType logic to the core module (perhaps delegating this call from the core to the QueryEngine instance)

Issue Links

• is related to: IGNITE-18303 Calcite engine. Fix nanoseconds flakyness in LocalDateTimeSupportTest
• is related to: IGNITE-17226 Calcite engine. Make calcite engine independent of H2 and ignite-indexing
• links to: GitHub Pull Request #10399