[
https://issues.apache.org/jira/browse/CALCITE-4085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17148145#comment-17148145
]
Dawid Wysakowicz edited comment on CALCITE-4085 at 6/29/20, 9:27 PM:
---------------------------------------------------------------------
BTW, just out of curiosity. Could you point me to the exert from the SQL
standard that is reflected by the said logic? If I am not mistaken SQL does not
allow constraints on attributes nor fields, making all fields and attributes
nullable irrespective of the nullability of the column. I think the nested
nullability is a Calcite behavior(which personally I like). I'd like to
understand though why the original nullability can not preserved.
was (Author: dawidwys):
BTW, just out of curiosity. Could you point me to the exert from the SQL
standard that is reflected by the said logic? If I am not mistaken SQL does not
allow constraints on attributes nor fields, making all fields and attributes
nullable irrespective of the nullability of the column. I think the nested
nullability is a Calcite behavior(which personally I like). I'd like to
understand though why the original nullability is not preserved.
> Improve nullability support for fields of structured type
> ---------------------------------------------------------
>
> Key: CALCITE-4085
> URL: https://issues.apache.org/jira/browse/CALCITE-4085
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Dawid Wysakowicz
> Assignee: Dawid Wysakowicz
> Priority: Major
> Time Spent: 20m
> Remaining Estimate: 0h
>
> As discussed in
> https://lists.apache.org/thread.html/r602ac95fff23dd1ef974fb396df7be061ab861384ec42f5c57ce0bc2%40%3Cdev.calcite.apache.org%3E
> I would like to change the way a type of a field of a record is derived at
> couple of locations. This helps frameworks such as Apache Flink to build
> support for nullable records with not null fields.
> I suggest to change:
> * SqlDotOperator#deriveType
> * SqlItemOperator#inferReturnType
> * AliasNamespace#validateImpl
> * RexBuilder#makeFieldAccessInternal
> * SqlValidatorImpl.DeriveTypeVisitor#visit(SqlIdentifier)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
