Danny Chan created CALCITE-3201: ----------------------------------- Summary: Skip validation for sql insert columns with column strategy that can not insert into Key: CALCITE-3201 URL: https://issues.apache.org/jira/browse/CALCITE-3201 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.20.0 Reporter: Danny Chan Assignee: Danny Chan Fix For: 1.21.0
Now if we have a target table with schema: {code:sql} t1 : - a int not null - b bigint STORED - c varchar VIRTUAL {code} and validate a query like: {code:sql} insert into t1 select a from t1; {code} It would throw exception because the target table fields count is 3 but the query is 1, actually the table t1 columns b and c have strategy that we can not insert into, so we better ignore these columns when do validation -- This message was sent by Atlassian JIRA (v7.6.14#76016)