Ran Cao created CALCITE-3606: -------------------------------- Summary: batch insert failed Key: CALCITE-3606 URL: https://issues.apache.org/jira/browse/CALCITE-3606 Project: Calcite Issue Type: Wish Components: core Affects Versions: 1.21.0 Reporter: Ran Cao
when I try to execute sql like (insert into example_table (column1,column2) values (value1,value2),(value1,value2)), it will failed with error message like this: column "EXPR$0" of relation "example_table" does not exist. I find the reason is that when converting SqlNode(insert sql) to RelNode(TableModify), one of the steps is to change the column that stored in RelDataType from the fake column name (like "EXPR$0") to the real column name (like "id"). But when the values part in sql is more than one , the step above-mentioned will skip because the RelNode is instance of LogicalUnion instead of Project, the code refered to org.apache.calcite.tools.RelBuilder line 1461: if (input instanceof Project && fieldNames != null) { // change the column name } -- This message was sent by Atlassian Jira (v8.3.4#803005)