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

Index aggregates pushdown wrongly

    XMLWordPrintable

Details

    • 1

    Description

      CREATE INDEX cx1 ON default(type, a1 );
       
      UPSERT INTO default VALUES ("c001", {"type": "doc", "a1":[{"name":"a1"}, {"name":"a2"}]}),
                          VALUES ("c002", {"type": "doc", "a1":[{"name":"b1"}, {"name":"a2"}]}),
                          VALUES ("c003", {"type": "doc", "a1":[{"name":"b1"}, {"name":"a2"}]});
       
      SELECT COUNT(1) FROM default AS d
      WHERE d.type = "doc" AND (EVERY v IN a1 SATISFIES v.name != "b1" END OR d.a1 IS MISSING);
       
      SELECT * FROM default AS d
      WHERE d.type = "doc" AND (EVERY v IN a1 SATISFIES v.name != "b1" END OR d.a1 IS MISSING);
      

      count query returns 3, non-count query returns 1

      Index is not array Index. array field is Scalar value. count query can cover. But the EVERY predicate is not pushed to indexer. It should not push index aggregation.
      Also note EVERY query can't push any index pushdowns.

      Workaround:
      SELECT COUNT(1) FROM default AS d WHERE d.type = "doc" AND (EVERY v IN IFMISSING(a1,[]) SATISFIES v.name != "b1" END);
      EVERY is true for empty ARRAY.

      Attachments

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

        Activity

          There are no commits yet on this issue.

          People

            mihir.kamdar Mihir Kamdar (Inactive)
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty