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

sargable/sarg should check SATISFIES for non array index key

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • feature-backlog
    • 7.1.0
    • query
    • None
    • 1

    Description

      create index ix20 on default(DISTINCT c1,c2);
      explain SELECT 1 from default where ANY v IN c1 SATISFIES v = 10 AND c2 = 20 END;

      c2 = 20 should able to sargable and push to indexer. If moved outside ANY it does.

      subset/sargable/sarg should handle combinations of (normal key/arraykey, normal predicate/ANY/ANY AND EVERY SATISFIES)

      Attachments

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

        Activity

          People

            Unassigned Unassigned
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty