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

NULLIF topic in reference manual should explain NULLIF

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.8.2.2
    • 10.9.1.0
    • Documentation
    • 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
          Camilla Haase
        2. DERBY-5557-2.diff
          6 kB
          Camilla Haase
        3. DERBY-5557-2.stat
          0.1 kB
          Camilla Haase
        4. DERBY-5557-2.zip
          11 kB
          Camilla Haase
        5. rrefcasenullif.html
          3 kB
          Camilla Haase

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: