[
https://issues.apache.org/jira/browse/IGNITE-18831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-18831:
--------------------------------------
Labels: ignite-3 (was: calcite2-required ignite-3)
> Sql. Dynamic parameters. Inferred types of dynamic parameters are not used by
> the execution runtime.
> ----------------------------------------------------------------------------------------------------
>
> Key: IGNITE-18831
> URL: https://issues.apache.org/jira/browse/IGNITE-18831
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Maksim Zhuravkov
> Assignee: Maksim Zhuravkov
> Priority: Minor
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 2h 10m
> Remaining Estimate: 0h
>
> Rewrite validation dynamic parameters by moving type checking of dynamic
> parameters to TypeCoercion.
> Introduce type compatibly checks for dynamic parameters:
> {code:java}
> OK: SELECT * FROM t WHERE int_col = ?:int
> OK: SELECT * FROM t WHERE int_col = ?:smallint
> SELECT * FROM t WHERE int_col = cast(?:smallint, int)
> ERR: SELECT * FROM t WHERE int_col = ?:str
> ERR: SELECT * FROM t WHERE str_col = ?:int
> ERR: SELECT 1 + ?:str
> ERR: SELECT ?:str + ?:str
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
