[ https://issues.apache.org/jira/browse/DERBY-1576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14004422#comment-14004422 ]
ASF subversion and git services commented on DERBY-1576: -------------------------------------------------------- Commit 1596492 from [~knutanders] in branch 'code/trunk' [ https://svn.apache.org/r1596492 ] DERBY-1576: Extend the CASE expression syntax for "simple case" Forbid untyped parameters in the case operand. > 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, d1576-2a.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)