Derby
  1. Derby
  2. DERBY-2441

The documentation for NULLIF could be improved

    Details

    • Type: Task Task
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Invalid
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      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

        Activity

        Kathey Marsden created issue -
        Kathey Marsden made changes -
        Field Original Value New Value
        Resolution Invalid [ 6 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Kathey Marsden made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12399245 ] Default workflow, editable Closed status [ 12797646 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Kathey Marsden
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development