[jira] [Updated] (IGNITE-14749) Calcite engine. Create table and use of this table in one statement doesn't work

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

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

Yury Gerzhedovich updated IGNITE-14749:
---------------------------------------
    Labels: calcite3-required  (was: calcite2-required calcite3-required)

> Calcite engine. Create table and use of this table in one statement doesn't work
> --------------------------------------------------------------------------------
>
>                 Key: IGNITE-14749
>                 URL: https://issues.apache.org/jira/browse/IGNITE-14749
>             Project: Ignite
>          Issue Type: Bug
>            Reporter: Aleksey Plekhanov
>            Assignee: Ivan Daschinsky
>            Priority: Major
>              Labels: calcite3-required
>          Time Spent: 1h 40m
>  Remaining Estimate: 0h
>
>  
> If a statement consists of substatements and a table is created in one of these substatement and then used by another, preparation of this statement failed. For example: 
> {code:java}
> executeSql("CREATE TABLE test (val int); INSERT INTO test VALUES (0);");
> {code}
> Failed with:
>  
> {noformat}
> Caused by: org.apache.calcite.tools.ValidationException: org.apache.calcite.runtime.CalciteContextException: From line 1, column 42 to line 1, column 45: Object 'TEST' not found
>   at org.apache.ignite.internal.processors.query.calcite.prepare.IgnitePlanner.validate(IgnitePlanner.java:180)
>   at org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.prepareDml(ExecutionServiceImpl.java:597)
>   at org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.prepareSingle(ExecutionServiceImpl.java:561)
>   at org.apache.ignite.internal.processors.query.calcite.exec.ExecutionServiceImpl.prepareQuery(ExecutionServiceImpl.java:520)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)