[ https://issues.apache.org/jira/browse/DERBY-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden closed DERBY-2441. --------------------------------- > The documentation for NULLIF could be improved > ---------------------------------------------- > > Key: DERBY-2441 > URL: https://issues.apache.org/jira/browse/DERBY-2441 > Project: Derby > Issue Type: Task > Components: Documentation > Affects Versions: 10.3.0.0 > Reporter: Kathey Marsden > Priority: Trivial > > The documentation for NULLIF could be improved as it doesn't explain what > NULLIF does at > http://db.apache.org/derby/manuals/reference/sqlj66.html#NULLIF+and+CASE+expressions > I believe the behaviour is that if both arguments are equal it returns NULL > otherwise it returns the first value > e.g. > NULLIF(L, R) > is equivalent to: > CASE WHEN L=R THEN NULL ELSE L END -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.