Details
-
Bug
-
Resolution: Unresolved
-
Major
-
6.5.0
-
6.5.0-4558
-
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": [
]
}
}