[ https://issues.apache.org/jira/browse/CALCITE-6149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mihai Budiu resolved CALCITE-6149. ---------------------------------- Fix Version/s: 1.37.0 Resolution: Fixed Closed in https://github.com/apache/calcite/pull/3556 Thank you, [~chen768959] > ClickHouseSqlDialect should support cast to Nullable > ---------------------------------------------------- > > Key: CALCITE-6149 > URL: https://issues.apache.org/jira/browse/CALCITE-6149 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.36.0 > Reporter: ChenLuyang > Priority: Minor > Labels: dialect, pull-request-available > Fix For: 1.37.0 > > > In ClickHouse, there is an issue with RelDataType of Nullable type when > casting to a non-Nullable type. For example, {{SELECT CAST(NULL, 'Int32')}} > will throw an error. In such cases, we should use {{SELECT CAST(NULL, > 'Nullable(Int32)')}} instead. > > related error messages. > DB::Exception: Cannot convert NULL value to non-Nullable type -- This message was sent by Atlassian Jira (v8.20.10#820010)