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

          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:

                PagerDuty