Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-5789

[SQL] CASE CAST(.. as DATE) ELSE NULL doesn't work

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • P3
    • Resolution: Unresolved
    • None
    • None
    • dsl-sql
    • None

    Description

      CASE CAST(.. as DATE) ELSE NULL    seem to result in multiple conversions from string to date. That chain seems to fail as one of the string representations of the date is not supported by CAST expression.

      Source: https://stackoverflow.com/questions/52861989/how-does-calcite-deal-with-data-conversion/52878780

      Attachments

        Activity

          People

            Unassigned Unassigned
            kedin Anton Kedin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: