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

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

Aleksey Plekhanov created IGNITE-14749:
------------------------------------------

             Summary: 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


 

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)