[jira] [Updated] (IGNITE-21097) Sql. Infer dynamic parameter types in scripts.
[ https://issues.apache.org/jira/browse/IGNITE-21097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-21097: -- Summary: Sql. Infer dynamic parameter types in scripts. (was: Sql. Infer dynamic parameter types for scripts.) > Sql. Infer dynamic parameter types in 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)
[jira] [Updated] (IGNITE-21097) Sql. Infer dynamic parameter types for scripts.
[ https://issues.apache.org/jira/browse/IGNITE-21097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-21097: -- Summary: Sql. Infer dynamic parameter types for scripts. (was: Sql. Infer parameter types for scripts.) > Sql. Infer dynamic 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)
