[
https://issues.apache.org/jira/browse/DERBY-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden resolved DERBY-2441.
-----------------------------------
Resolution: Invalid
Kim pointed out that this had already been resolved. I was looking at older
documentation.
> 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.
