[jira] [Created] (IGNITE-29115) SQL Calcite: Fix UDF/UDTF overload resolution for concrete and generic argument types

["Kirill Tkalenko (Jira)" <ji...@apache.org>]

Kirill Tkalenko created IGNITE-29115:
----------------------------------------

             Summary: SQL Calcite: Fix UDF/UDTF overload resolution for concrete and generic argument types
                 Key: IGNITE-29115
                 URL: https://issues.apache.org/jira/browse/IGNITE-29115
             Project: Ignite
          Issue Type: Bug
            Reporter: Kirill Tkalenko
            Assignee: Kirill Tkalenko


Calcite fails to resolve UDF overloads correctly when concrete SQL types coexist with a generic {{Object}} parameter ({{{}OTHER{}}}/{{{}ANY{}}}). Calls may fail with {{AssertionError: OTHER}} instead of invoking the matching overload.

Example:
{code:java}
@QuerySqlFunction
public String foo(String value) { return "String"; }

@QuerySqlFunction
public String foo(Timestamp value) { return "Timestamp"; }

@QuerySqlFunction
public String foo(Object value) { return "Object"; } {code}
Expected behavior:
{code:java}
SELECT UDF.FOO('text');                          -- String overload
SELECT UDF.FOO(TIMESTAMP '2024-01-02 03:04:05');  -- Timestamp overload
SELECT UDF.FOO(?);                               -- Object overload for a Person instance {code}
Resolve overloads by preferring the most specific compatible concrete type and using Object as a generic fallback. Support scalar and table functions, SQL literals, query parameters, nested function calls, and SQL expression chains based on the resulting argument type.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)