[IGNITE-18761] Sql. TypeOf can short-circuit only when its argument is a constant expression.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Maksim Zhuravkov
• Reporter: Maksim Zhuravkov
• Created: 08/Feb/23 11:34
• Updated: 10/Oct/24 18:14
• Resolved: 03/May/23 10:49

Description

The current implement of typeof simply checks the type its operand but this is not correct because the operand maybe an invalid expression or a function that produces a side effect.
MRE:

assertThrows(RuntimeException.class, () -> assertQuery("SELECT TYPEOF(CAST('NOT_A_NUMBER' AS INTEGER))").check());

This query should return an error but it returns a string INTEGER.

Issue Links

• is related to: IGNITE-23408 Calcite. 'Typeof' should fail in case of incorrect parameter.
• links to: GitHub Pull Request #2000
• links to: https://github.com/apache/ignite-3/pull/2000