[
https://issues.apache.org/jira/browse/CALCITE-3213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16893314#comment-16893314
]
Julian Hyde commented on CALCITE-3213:
--------------------------------------
I generally agree. Can you clarify: is that SQL standard syntax?
Also, I recall that standard SQL does not like {{NOT NULL}} constraints in
complex types. (Not that we shouldn't do them. I just want to be clear what is
standard and what is not.)
> Support complex type expressions for SqlDataTypeSpec
> -----------------------------------------------------
>
> Key: CALCITE-3213
> URL: https://issues.apache.org/jira/browse/CALCITE-3213
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.20.0
> Reporter: Danny Chan
> Assignee: Danny Chan
> Priority: Major
> Fix For: 1.21.0
>
>
> We should support nested struct type like:
> {code:sql}
> ROW(
> NUMBER(5, 2) NOT NULL AS foo,
> ROW(BOOLEAN AS b, MyUDT NOT NULL AS i) AS rec)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
