[IGNITE-14617] Calcite. Add opportunity to use NUMERIC in WHEN syntax.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite calcite2-required calcite3-required
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 21/Apr/21 12:10
• Updated: 18/Jun/21 09:33

Description

Probably we need to support such kind of expressions:

SELECT CASE WHEN 1 THEN 13 ELSE 12 END;

WHEN 1=1 - works correctly in such case. Additional info was given in [1]

[1] https://issues.apache.org/jira/browse/IGNITE-14612

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• relates to: IGNITE-14612 Calcite. SELECT with CASE without boolean expression - fails.