Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.0
-
Untriaged
-
Yes
Description
In 6.5.0-2715 and up.
Create default bucket
Create primary index on default
CREATE INDEX ix1 ON default(docid,name)
CREATE INDEX ix2 ON default(docid,name) where type = "wdoc"
CREATE INDEX ix3 ON default(altid, name, DISTINCT ARRAY p FOR p IN phones END)
INSERT into default (key , value) VALUES ("w001",
{'docid': 'x001', 'altid': 'x001', 'type': 'wdoc', 'name': 'wdoc', 'phones': ['123-456-7890', '123-456-7891']})
INSERT into default (key , value) VALUES ("pdoc1",
)
INSERT into default (key , value) VALUES ("pdoc2",
)
Then run:
SELECT meta(b1).id b1id from default b1 NEST default b2 ON KEY b2.docid FOR b1 WHERE meta(b1).id > ""
This query will hang forever even though there are only 3 documents.
Logs are attached