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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Ivan Daschinsky
• Reporter: Aleksey Plekhanov
• Created: 20/May/21 12:53
• Updated: 16/Nov/21 15:57
• Resolved: 09/Aug/21 13:22

Description

 

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: 

executeSql("CREATE TABLE test (val int); INSERT INTO test VALUES (0);");

Failed with:

 

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)

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #9291