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

N1QL: Array Indexing: meta with an array index should be covered inspite of the particular array field being present in the index

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 4.5.0
    • query
    • None

    Description

      As of today the following meta query:
      EXPLAIN SELECT meta().id FROM default WHERE ANY v IN b SATISFIES v.x > 10 END;

      shows meta is covered if the particular array index has b also in it.

      Array Index:
      CREATE INDEX `ix` ON `default`((distinct (array (`v`.`x`) for `v` in `b` end)),b)

      But meta should be covered whether or not b is part of ix array index or not.
      i.e.
      CREATE INDEX `iy` ON `default`((distinct (array (`v`.`x`) for `v` in `b` end)))
      should also cover meta in above query.

      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:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty