[
https://issues.apache.org/jira/browse/IGNITE-23242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-23242:
--------------------------------------
Summary: Sql. Validator accepts functions that do not exist in runtime. It
is not possible to call f(INTEGER) with f(BIGINT) (was: Sql. Validator accepts
functions that do not exist in runtime)
> Sql. Validator accepts functions that do not exist in runtime. It is not
> possible to call f(INTEGER) with f(BIGINT)
> -------------------------------------------------------------------------------------------------------------------
>
> Key: IGNITE-23242
> URL: https://issues.apache.org/jira/browse/IGNITE-23242
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> The following functions when called with BIGINT arguments at integer
> positions are accepted by the validator, but execution of such functions
> fails with runtime errors
> {code:java}
> * OVERLAY: while resolving method 'overlay
> * REPEAT: while resolving method 'repeat
> * SUBSTRING: while resolving method 'substring
> * CHR: while resolving method 'charFromUtf8
> * LEFT: while resolving method 'left
> * RIGHT: while resolving method 'right
> * SPACE: while resolving method in class class ...
> * POSITION: while resolving method 'position
> {code}
> Example with CHR(INT) function.
> {code:java}
> @Test
> public void test() {
> sql("SELECT CHR(1000::BIGINT)");
> }
> {code}
> {noformat}
> org.apache.ignite.sql.SqlException: IGN-CMN-65535
> TraceId:6002aa38-1fae-4e4e-b56c-a8134d3ed2dc while resolving method
> 'charFromUtf8[long]' in class class org.apache.calcite.runtime.SqlFunctions
> ....
> Caused by: java.lang.NoSuchMethodException:
> org.apache.calcite.runtime.SqlFunctions.charFromUtf8(long)
> at java.base/java.lang.Class.getMethod(Class.java:2108)
> at
> org.apache.calcite.adapter.enumerable.EnumUtils.call(EnumUtils.java:663)
> ... 37 more
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
