[ http://issues.apache.org/jira/browse/DERBY-1575?page=all ]
Jean T. Anderson updated DERBY-1575:
------------------------------------
Fix Version/s: 10.2.1.0
(was: 10.2.2.0)
Merged to 10.2 branch on Fri Sep 01.
> document full syntax of CASE expression
> ---------------------------------------
>
> Key: DERBY-1575
> URL: http://issues.apache.org/jira/browse/DERBY-1575
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Reporter: Christian d'Heureuse
> Assigned To: Kim Haase
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: DERBY-1575.diff, DERBY-1575_fix.diff, rrefcasenullif.html
>
>
> The documentation at
> http://db.apache.org/derby/docs/dev/ref/rrefcasenullif.html describes the
> CASE expression syntax as:
> CASE WHEN BooleanExpression THEN thenExpression ELSE elseExpression END
> But the CASE expression supports more than one WHEN/THEN clauses.
> I suggest to change the syntax description to:
> CASE
> WHEN BooleanExpression THEN Expression
> [ WHEN BooleanExpression THEN Expression ]
> ...
> ELSE elseExpression
> END
> Example:
> VALUES
> CASE
> WHEN 1 = 2 THEN 3
> WHEN 4 = 5 THEN 6
> ELSE 7
> END
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
