[CALCITE-53] Allow WHEN clause in simple CASE expression to have multiple values

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 07:55
• Updated: 18/Jun/14 07:56
• Resolved: 18/Jun/14 07:56

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