[jira] [Created] (CALCITE-3201) Skip validation for sql insert columns with column strategy that can not insert into

["Danny Chan (JIRA)" <ji...@apache.org>]

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)