[
https://issues.apache.org/jira/browse/IGNITE-19469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-19469:
--------------------------------------
Description:
Calls to SUBSTR function with arguments of not compatible types does not cause
validation errors in some cases:
{noformat}
# 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
{noformat}
was:
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}
> 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:
> {noformat}
> # 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
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
