You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2021/08/05 09:45:00 UTC

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

    [ https://issues.apache.org/jira/browse/IGNITE-14749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17393759#comment-17393759 ] 

Evgeny Stanilovsky commented on IGNITE-14749:
---------------------------------------------

looks good , [~korlov] [~alex_pl] plz take a look ?

> 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: calcite2-required, calcite3-required
>          Time Spent: 0.5h
>  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)