You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "jackylau (Jira)" <ji...@apache.org> on 2023/04/25 08:28:00 UTC

[jira] [Closed] (CALCITE-5672) cast type with nullable result it not true

     [ https://issues.apache.org/jira/browse/CALCITE-5672?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

jackylau closed CALCITE-5672.
-----------------------------
    Resolution: Duplicate

> cast type with nullable result it not true
> ------------------------------------------
>
>                 Key: CALCITE-5672
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5672
>             Project: Calcite
>          Issue Type: Improvement
>    Affects Versions: 1.34.0
>            Reporter: jackylau
>            Priority: Major
>
> {code:java}
> // code placeholder
> sql("select cast(array[1,null,2] as int array) from (values (1))")
>     .columnType("INTEGER NOT NULL ARRAY NOT NULL"); {code}
> it should be INTEGER ARRAY NOT NULL, the nullable constraint is table level, the expr's nullable property should not change



--
This message was sent by Atlassian Jira
(v8.20.10#820010)