[
https://issues.apache.org/jira/browse/CALCITE-1510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15694135#comment-15694135
]
Julian Hyde commented on CALCITE-1510:
--------------------------------------
I believe (can someone please confirm/deny), that on Oracle, if I say {{insert
into emp values (100, 20, 'Fred')}} and {{emp}} has 4 columns {{empno int,
deptno int, name varchar(20), comm number}}, Oracle will give an error. If so,
we will need a new conformance method to allow this.
Now, I believe that you can say {{insert into emp (empno, deptno, name) values
(100, 20, 'Fred')}}, but that is not what we are talking about here.
> INSERT/UPSERT should allow values less than number of columns
> -------------------------------------------------------------
>
> Key: CALCITE-1510
> URL: https://issues.apache.org/jira/browse/CALCITE-1510
> Project: Calcite
> Issue Type: Improvement
> Reporter: Rajeshbabu Chintaguntla
> Assignee: Julian Hyde
>
> Currently calcite not allowing to write if the values less than number of
> columns. We can write the leading columns with the all values and remaining
> columns can be considered as null or else we can allow specifying columns and
> corresponding values. Ping [~julianhyde] [~jamestaylor] [~maryannxue].
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
