Derby
  1. Derby
  2. DERBY-5557

NULLIF topic in reference manual should explain NULLIF

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major 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.

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

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development