[ https://issues.apache.org/jira/browse/DERBY-6560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13987635#comment-13987635 ]
Knut Anders Hatlen commented on DERBY-6560: ------------------------------------------- Thanks, Kim. That looks exactly right. +1 to commit. > Reference manual says ELSE clause is required in CASE expressions > ----------------------------------------------------------------- > > Key: DERBY-6560 > URL: https://issues.apache.org/jira/browse/DERBY-6560 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.10.2.0 > Reporter: Knut Anders Hatlen > Assignee: Kim Haase > Priority: Minor > Attachments: DERBY-6560.diff, rrefcase.html > > > The reference manual topic on the CASE expression says the syntax is > {noformat} > CASE > WHEN booleanExpression THEN thenExpression > [ WHEN booleanExpression THEN thenExpression ]* > ELSE elseExpression > END > {noformat} > The ELSE clause is optional and should be in square brackets, as seen by this > example: > {noformat} > ij> values case when (1<>1) then 'yes' end; > 1 > ---- > NULL > 1 row selected > {noformat} > This seems to comply with the SQL standard, as the syntax rules for <case > expression> say that "\[if\] an <else clause> is not specified, then ELSE > NULL is implicit." -- This message was sent by Atlassian JIRA (v6.2#6252)