db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1575) document full syntax of CASE expression
Date Tue, 29 Aug 2006 21:50:24 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1575?page=all ]

Kim Haase updated DERBY-1575:
-----------------------------

    Attachment: DERBY-1575_fix.diff
                rrefcasenullif.html

I'm really sorry I garbled the syntax. I've attached a corrected patch (DERBY-1575_fix.diff)
and the HTML output file, rrefcasenullif.html. Hope I got it right this time.

I think you might want to file a separate issue for the functionality question you raise,
since it's not really a documentation issue.

> 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
>         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

        

Mime
View raw message