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

NULLIF topic in reference manual should explain NULLIF

    XMLWordPrintableJSON

    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-2.zip
          11 kB
          Camilla Haase
        2. DERBY-5557-2.stat
          0.1 kB
          Camilla Haase
        3. DERBY-5557-2.diff
          6 kB
          Camilla Haase
        4. DERBY-5557.diff
          0.7 kB
          Camilla Haase
        5. rrefcasenullif.html
          3 kB
          Camilla Haase

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: