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

ARRAY KEY predicate is not pushed to indexer it should not cover without whole array in the index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.6.4, 5.1.0, 5.5.0
    • 4.6.2, 5.0.0
    • query
    • None
    • Untriaged
    • Yes

    Description

      INSERT INTO default VALUES("k01",{"k0":"XYZ","ka":["abc"]});
      CREATE INDEX ix11 ON default(k0,k1,DISTINCT ARRAY v FOR v IN ka END);
      SELECT META().id FROM default WHERE k0 = "XYZ" AND ANY v IN ka SATISFIES v LIKE "def%" END;
      

      Above query covers it shouldn't because Array key is not pushed to indexer due to k1 is missing in predicate. We need ka in the index re-apply predicate. Array index keys can be covered without array in index when all predicates pushed to indexer and no false positives possible. Otherwise we can't use filtercovers for that arraykey

      Attachments

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

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty