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

N1QL logical operations truth table inconsistent in docs

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • Neo.M1
    • Cheshire-Cat, 6.x Doc Updates, Neo
    • None

    Description

      For 'MISSING OR NULL' and for 'NULL OR MISSING', the truth tables in

      A) https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/logicalops.html ==> says the result should be MISSING
      and
      B) https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/booleanlogic.html ==> says the result should be NULL

      Playing with the N1QL online tutorial of 'SELECT MISSING OR NULL, NULL OR MISSING' it seems that the truth table on page #B is correct and the truth table on page #A is incorrect.

      Reporter: Steve Yen
      E-mail: steve@couchbase.com

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            simon.dew Simon Dew
            steve Steve Yen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty