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

Query with meta in [""] with primary index gives duplicate results

    XMLWordPrintable

Details

    • Untriaged
    • No

    Description

      Secondary Scan on primary index with low="",high="", inclusive=3 produces all items on the bucket.
      Secondary Scan on secondary index (attributes) works correctly.

      Following scenario gives duplicate results.

      create primary index on default;
      insert into default values ("k01",{"name":"abc"});
      select name,meta().id from default where meta().id IN ["k01",""];
      

      Test affected: test_stable_scan in tuqquery.tuq_2i_index.QueriesIndexTests

      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)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty