[ https://issues.apache.org/jira/browse/DERBY-1576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14001492#comment-14001492 ]
Knut Anders Hatlen commented on DERBY-1576: ------------------------------------------- Thanks, Dag. I've committed the 1a patch as a first increment. > Extend the CASE expression syntax for "simple case" > --------------------------------------------------- > > Key: DERBY-1576 > URL: https://issues.apache.org/jira/browse/DERBY-1576 > Project: Derby > Issue Type: Improvement > Components: SQL > Reporter: Christian d'Heureuse > Assignee: Knut Anders Hatlen > Priority: Minor > Labels: derby_triage10_11 > Attachments: d1576-1a.diff, simple-simple.diff > > > The ISO/IEC 9075-2:1999 SQL standard describes two kinds of CASE expressions: > "simple case" and "searched case". > The current Derby version supports "searched case" but not "simple case". > The syntax for "simple case" is: > CASE Expression > WHEN Expression THEN Expression > [ WHEN Expression THEN Expression ] > ... > ELSE ElseExpression > END > Example: > VALUES > CASE 4 > WHEN 1 THEN 'one' > WHEN 2 THEN 'two' > WHEN 3 THEN 'three' > ELSE 'many' > END -- This message was sent by Atlassian JIRA (v6.2#6252)