You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kim Haase (Resolved) (JIRA)" <ji...@apache.org> on 2012/04/12 19:39:20 UTC

[jira] [Resolved] (DERBY-5557) NULLIF topic in reference manual should explain NULLIF

     [ https://issues.apache.org/jira/browse/DERBY-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase resolved DERBY-5557.
------------------------------

          Resolution: Fixed
       Fix Version/s: 10.9.0.0
    Issue & fix info:   (was: Patch Available)

Thanks, Knut! Haven't seen a commit email after several hours, but maybe it's just me.

Committed patch DERBY-5557-2.diff to documentation trunk at revision 1325247. 

                
> NULLIF topic in reference manual should explain NULLIF
> ------------------------------------------------------
>
>                 Key: DERBY-5557
>                 URL: https://issues.apache.org/jira/browse/DERBY-5557
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.8.2.2
>            Reporter: Knut Anders Hatlen
>            Assignee: Kim Haase
>             Fix For: 10.9.0.0
>
>         Attachments: DERBY-5557-2.diff, DERBY-5557-2.stat, DERBY-5557-2.zip, DERBY-5557.diff, rrefcasenullif.html
>
>
> The section describing NULLIF in the reference manual is a bit cryptic. http://db.apache.org/derby/docs/10.8/ref/rrefcasenullif.html
> It says that NULLIF is used for conditional expressions, and that it is similar to CASE, but it doesn't say in plain words how it works. It would be good if it could mention that NULLIF returns NULL if the two arguments are equal, and that it returns the first argument if they are not equal.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira