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

        Activity

        Hide
        github-import GitHub Import added a comment -

        [Date: Fri Sep 20 19:53:21 CEST 2013, Author: julianhyde]

        I added disabled test cases to SqlOperatorBaseTest.testCase.

        Show
        github-import GitHub Import added a comment - [Date: Fri Sep 20 19:53:21 CEST 2013, Author: julianhyde ] I added disabled test cases to SqlOperatorBaseTest.testCase.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development