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

    • Untriaged
    • 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

            ali.alsuliman Ali Alsuliman
            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