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

Correctly compare expressions with NULL and MISSING during index selection

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.5.1, 5.0.0
    • 4.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      See https://forums.couchbase.com/t/secondary-index-entries-for-docs-with-missing-key-values/9183/5

      During index selection, we compare the expression in the index key with the expression in the query predicate for equivalence. For this comparison, NULL should compare as equivalent to NULL, and MISSING should compare as equivalent to MISSING.

      Because the comparison is not happening correctly, the user is unable to use an index on IFMISSING(field, NULL).

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MB-19612 4.5.1 Minor Release

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              gerald Gerald Sangudi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty