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

Allow WHEN clause in simple CASE expression to have multiple values

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    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

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment