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

Allow WHEN clause in simple CASE expression to have multiple values

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      From SQL:2011 you can have multiple values in a WHEN clause of a simple CASE.

      CASE x WHEN 1 THEN 'x' WHEN 2, 3 THEN 'y' END

      Previously you'd have to write

      CASE x WHEN 1 THEN 'x' WHEN 2 THEN 'y' WHEN 3 THEN 'y' END

      to achieve the same thing.

      ---------------- Imported from GitHub ----------------
      Url: https://github.com/julianhyde/optiq/issues/53
      Created by: julianhyde
      Labels: enhancement,
      Created at: Fri Sep 20 19:52:27 CEST 2013
      State: closed

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              github-import GitHub Import
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: