Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-9906

Add IS [NOT] DISTINCT to boolean logic documentation

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • Morpheus
    • Morpheus
    • query
    • None
    • 1

    Description

      Add syntax to tables:

      a IS DISTINCT FROM b:

      • a or b is MISSING -> MISSING
      • a is NULL and b is non-NULL -> TRUE
      • a is non-NULL and b is NULL -> TRUE
      • a is NULL and b is NULL -> FALSE
      • a and b are non-NULL, non-MISSING then the result is the same as a != b

      a IS NOT DISTINCT FROM b:

      • a or b is MISSING -> MISSING
      • a is NULL and b is non-NULL -> FALSE
      • a is non-NULL and b is NULL -> FALSE
      • a is NULL and b is NULL -> TRUE
      • a and b are non-NULL, non-MISSING then the result is the same as a == b

       

      Attachments

        Activity

          People

            simon.dew Simon Dew
            Donald.haggart Donald Haggart
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              PagerDuty