Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-18542

ANY AND EVERY expression for array indexing

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.5.0
    • 4.5.0
    • query
    • None

    Description

      N1QL has two quantifiers, ANY and EVERY. We need a third, ANY AND EVERY.

      ANY returns TRUE if the input is non-empty here is at least one match.

      EVERY returns TRUE if (1) the input is empty, or (2) the input is non-empty and every element is a match.

      We need a third quantifier, ANY AND EVERY, that returns TRUE only if the input is non-empty and every element is a match. In addition to conciseness, an important benefit is that this quantifier is usable with array indexing. Currently, ANY is usable with array indexing, but EVERY is not, because it is TRUE on empty input.

      Attachments

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

        Activity

          People

            gerald Gerald Sangudi (Inactive)
            gerald Gerald Sangudi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty