[
https://issues.apache.org/jira/browse/IGNITE-21097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-21097:
--------------------------------------
Description:
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 a DDL statement (because DDL statements 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 cannot be
perform in presence of DDL statements.
was:
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.
> 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 a DDL statement (because DDL statements 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 cannot
> be perform in presence of DDL statements.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
