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