Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5557

NULLIF topic in reference manual should explain NULLIF

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.2.2
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      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.

        Attachments

        1. DERBY-5557.diff
          0.7 kB
          Kim Haase
        2. DERBY-5557-2.diff
          6 kB
          Kim Haase
        3. DERBY-5557-2.stat
          0.1 kB
          Kim Haase
        4. DERBY-5557-2.zip
          11 kB
          Kim Haase
        5. rrefcasenullif.html
          3 kB
          Kim Haase

          Activity

            People

            • Assignee:
              chaase3 Kim Haase
              Reporter:
              knutanders Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: