[IGNITE-23590] Calcite. Introduce and fix types cast rules.

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.14
• Labels: calcite ignite-2 ise
• Ignite Flags: Release Notes Required
• Assignee: Unassigned
• Reporter: Vladimir Steshin
• Created: 01/Nov/24 15:38
• Updated: 02/Nov/24 16:26

Description

Calcite type cast rules differ from the standard. It should respect it. Consider:

// Works, but should not allow the cast at all.
assertQuery("SELECT CAST(timestamp '1992-09-26 02:30:00' AS BIGINT)").returns(717474600000L).check();

// Fails with `TINYINT overflow`, but should not allow the cast at all.
assertQuery("SELECT CAST(timestamp '1992-09-26 02:30:00' AS TINYINT)").returns(1).check();

Adoption of #IGNITE-20069

Issue Links

• relates to: IGNITE-20069 Sql. Not allowed conversion in CAST is possible.
• links to: GitHub Pull Request #11643