[jira] [Updated] (IGNITE-21097) Sql. Infer parameter types for scripts.

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

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

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

> Sql. Infer parameter types for scripts.
> ---------------------------------------
>
>                 Key: IGNITE-21097
>                 URL: https://issues.apache.org/jira/browse/IGNITE-21097
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Maksim Zhuravkov
>            Priority: Minor
>              Labels: ignite-3
>             Fix For: 3.0.0-beta2
>
>
> After https://issues.apache.org/jira/browse/IGNITE-20778 was resolved it is now possible to infer types of dynamic parameters for a single SQL statement. 
> Since SQL engine also provides API to execute SQL scripts, it should be possible to extend dynamic parameter type inference to scripts as well.
> There some limitations on supported statement types in SQL scripts to support type inference of dynamic parameters - type inference won't work if a script
> includes DDL statment (because DDL statement can make add/remove/change type columns, thus making type inference without DDL interpretation impossible).
> So if a script contains any DDL statement a process of inference of dynamic parameter type should report an error, indicating that type inference can not be
> perform in presence of DDL statements.



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