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

[ARRAY RQG] query returning extra results that are missing the requested field

    XMLWordPrintable

    Details

    • Triage:
      Untriaged
    • Is this a Regression?:
      Unknown

      Description

      I have a cluster with a kv,n1ql,index node and a kv,analytics node

      default bucket with data set defined by a yaml file and 50k docs
      dataverse called default

      CREATE INDEX `adv_type` ON `default`(`type`)

      SELECT id, owner, type FROM `default` WHERE EVERY p IN idents.accts.profids SATISFIES p.type = "shopfc" END AND type = 'links' ORDER BY id DESC, owner, type DESC

      analytics query:
      SELECT idents.accts FROM `default` d WHERE (EVERY p IN d.idents.accts.profids SATISFIES p.`type` = "shopfc" END) AND `type` = 'links' ORDER BY id DESC, owner, `type` DESC

      n1ql query returns 195 results

      matching analytics query returns 3598 results

      Logs and backups attached

      backup: https://www.dropbox.com/s/dcrfil3ne6volww/analyticsbug.tar.gz?dl=0

      However the analytics query is returns documents that DON'T match the criteria:

      looking at the accts field of these documents we see that most of the returned results do not even contain the profids field.

      {
      "accts": {
      "mems": [

      { "memid": 264, "progid": "VW", "validated": true }

      ]
      }
      }

        Attachments

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

          Activity

            People

            Assignee:
            dmitry.lychagin Dmitry Lychagin
            Reporter:
            ajay.bhullar Ajay Bhullar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Gerrit Reviews

                There are no open Gerrit changes

                  PagerDuty