Uploaded image for project: 'Couchbase Lite'
  1. Couchbase Lite
  2. CBL-1522

N1QL : Add NULL OR MISSING literal

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 3.0
    • 3.0
    • LiteCore
    • Security Level: Public
    • None
    • Jianmin 42
    • 5

    Description

      Add NULL OR MISSING literal. I'm not sure if having it into 3 words will work with the parser especially with OR in between. If not, we could do such as NULLORMISSING or NULL_OR_MISSING.

      Attachments

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

        Activity

          jianmin.zhao Jianmin Zhao added a comment -

          Approved by Pasin, we will make "IS NULLORMISSING" as an operator. Being an operator, as opposed to literal, NULLORMISSING cannot appear where an expression is expected. "x IS NULLORMISSING" is legit, whereas "x = NULLORMISSING" is not.

          jianmin.zhao Jianmin Zhao added a comment - Approved by Pasin, we will make "IS NULLORMISSING" as an operator. Being an operator, as opposed to literal, NULLORMISSING cannot appear where an expression is expected. "x IS NULLORMISSING" is legit, whereas "x = NULLORMISSING" is not.

          Build couchbase-lite-cblite-3.0.0-70 contains couchbase-lite-core commit cd76e1b with commit message:
          Add two operators: "IS VALUED" and "IS NOT VALUED". #CBL-1522 (#1131)

          build-team Couchbase Build Team added a comment - Build couchbase-lite-cblite-3.0.0-70 contains couchbase-lite-core commit cd76e1b with commit message: Add two operators: "IS VALUED" and "IS NOT VALUED". # CBL-1522 (#1131)

          Build couchbase-lite-log-3.0.0-71 contains couchbase-lite-core commit cd76e1b with commit message:
          Add two operators: "IS VALUED" and "IS NOT VALUED". #CBL-1522 (#1131)

          build-team Couchbase Build Team added a comment - Build couchbase-lite-log-3.0.0-71 contains couchbase-lite-core commit cd76e1b with commit message: Add two operators: "IS VALUED" and "IS NOT VALUED". # CBL-1522 (#1131)

          Build couchbase-lite-core-3.0.0-68 contains couchbase-lite-core commit cd76e1b with commit message:
          Add two operators: "IS VALUED" and "IS NOT VALUED". #CBL-1522 (#1131)

          build-team Couchbase Build Team added a comment - Build couchbase-lite-core-3.0.0-68 contains couchbase-lite-core commit cd76e1b with commit message: Add two operators: "IS VALUED" and "IS NOT VALUED". # CBL-1522 (#1131)

          Build couchbase-lite-ios-3.0.0-109 contains couchbase-lite-core commit cd76e1b with commit message:
          Add two operators: "IS VALUED" and "IS NOT VALUED". #CBL-1522 (#1131)

          build-team Couchbase Build Team added a comment - Build couchbase-lite-ios-3.0.0-109 contains couchbase-lite-core commit cd76e1b with commit message: Add two operators: "IS VALUED" and "IS NOT VALUED". # CBL-1522 (#1131)

          Build couchbase-lite-android-3.0.0-66 contains couchbase-lite-core commit cd76e1b with commit message:
          Add two operators: "IS VALUED" and "IS NOT VALUED". #CBL-1522 (#1131)

          build-team Couchbase Build Team added a comment - Build couchbase-lite-android-3.0.0-66 contains couchbase-lite-core commit cd76e1b with commit message: Add two operators: "IS VALUED" and "IS NOT VALUED". # CBL-1522 (#1131)

          Build couchbase-lite-java-3.0.0-66 contains couchbase-lite-core commit cd76e1b with commit message:
          Add two operators: "IS VALUED" and "IS NOT VALUED". #CBL-1522 (#1131)

          build-team Couchbase Build Team added a comment - Build couchbase-lite-java-3.0.0-66 contains couchbase-lite-core commit cd76e1b with commit message: Add two operators: "IS VALUED" and "IS NOT VALUED". # CBL-1522 (#1131)

          Build couchbase-lite-net-3.0.0-47 contains couchbase-lite-core commit cd76e1b with commit message:
          Add two operators: "IS VALUED" and "IS NOT VALUED". #CBL-1522 (#1131)

          build-team Couchbase Build Team added a comment - Build couchbase-lite-net-3.0.0-47 contains couchbase-lite-core commit cd76e1b with commit message: Add two operators: "IS VALUED" and "IS NOT VALUED". # CBL-1522 (#1131)

          People

            jianmin.zhao Jianmin Zhao
            pasin Pasin Suriyentrakorn
            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