[jira] [Updated] (IGNITE-19469) Sql. Functions. Type coercion of function arguments (SUBSTR function).

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-19469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maksim Zhuravkov updated IGNITE-19469:
--------------------------------------
    Labels: ignite-3  (was: )

> Sql. Functions. Type coercion of function arguments (SUBSTR function).
> ----------------------------------------------------------------------
>
>                 Key: IGNITE-19469
>                 URL: https://issues.apache.org/jira/browse/IGNITE-19469
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 3.0.0-beta1
>            Reporter: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> Calls to SUBSTR function with arguments of not compatible types does not cause validation errors in some cases:
> {code:java}
> # 1
> SELECT SUBSTR(100, 1)}
> IgniteProject(EXPR$0=[SUBSTR(_UTF-8'100':VARCHAR CHARACTER SET "UTF-8", 1)]), id = 20
>   IgniteValues(tuples=[[{ 0 }]]), id = 18
> # 2
> SELECT SUBSTR('123456789', '1')}
> IgniteProject(EXPR$0=[SUBSTR(_UTF-8'123456789', 1:BIGINT)]), id = 41
>   IgniteValues(tuples=[[{ 0 }]]), id = 39
> {code}
> # 3
> SELECT SUBSTR('0000'::UUID, 1)}
> IgniteProject(EXPR$0=[SUBSTR(CAST(_UTF-8'0000'):UUID NOT NULL, 1)]), id = 83
>   IgniteValues(tuples=[[{ 0 }]]), id = 81
> # 4
> SELECT SUBSTR('123456789', ?, 1)
> Dynamic parameters: [00000000-0000-0000-0000-000000000000 <java.util.UUID>]
> IgniteProject(EXPR$0=[SUBSTR(_UTF-8'123456789', ?0, 1)]), id = 104
>   IgniteValues(tuples=[[{ 0 }]]), id = 102
> {code}



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