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

Sargable index not sarged

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Yes

    Description

      CREATE INDEX ix20 ON default(ALL a1) WHERE type = "docs";
      SELECT d1, d2.id, d2.c2
      FROM default AS d1 USE KEYS "2345234"
      LEFT JOIN default AS d2 ON d2.type = "docs" AND ANY id IN d2.a1 SATISFIES id = META(d1).id END ;

       

      "errors": [
              {
                  "code": 4000,
                  "msg": "Sargable index not sarged; pred=(((`d2`.`type`) = \"docs\") and any `id` in (`d2`.`a1`) satisfies (`id` = (meta(`d1`).`id`)) end), sarg_keys=[(all ((`d2`.`a1`)))], error=Plan error: sarg.VisitAny: unexpected array id (0) for ANY expression any `id` in (`d2`.`a1`) satisfies (`id` = (meta(`d1`).`id`)) end"
              }
          ]

      Works 7.2.3

      Regression in 7.2.6, 7.6.2 due to  MB-61549

       

      Attachments

        Issue Links

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

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty