[IGNITE-19504] Sql. Align difference between ignite and calcite runtime available functions.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 17/May/23 12:30
• Updated: 15/Mar/24 08:30

Description

After [1] is done, we can proceed with functionality alignment.
IgniteSqlOperatorTable declare runtime available functions, thus undeclared functionality is not available for now, for example :

select left('Chicago', 5)

will throw: NoSuchMethodException, the goal of this issue is functionality aligment for such of undeclared functions and append additional tests.

Need to register :
SqlLibraryOperators.ENDS_WITH
SqlLibraryOperators.STARTS_WITH

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

Issue Links

• incorporates: IGNITE-15003 Calcite engine. Function argument is not casted implicitly