[jira] [Commented] (CALCITE-3213) Support complex type expressions for SqlDataTypeSpec

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ 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)