[
https://issues.apache.org/jira/browse/CALCITE-1510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15823035#comment-15823035
]
Kevin Liew commented on CALCITE-1510:
-------------------------------------
Thanks [~julianhyde]. I now have a good handle on what needs to be done. After
some discussion it was decided to leave materialization of default values to
the datastore, but validation still needs to be done based on nullability and
the existence of default values - I'd like to add a method to {{RelDataType}}
that indicates whether there exists a default values.
I noticed that the {{emps}} table has mostly non-nullable columns but
{{SqlValidatorTest.testInsert}} passes with only two source columns. Can you
point me to the definition for the {{emps}} table?
> 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
> Attachments: CALCITE-1510.patch
>
>
> 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)
