Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6149

ClickHouseSqlDialect should support cast to Nullable

    XMLWordPrintableJSON

Details

    Description

      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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              chen768959 ChenLuyang
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: