Description
|
INSERT INTO default VALUES ("f001", { "parent": "1496116023888_5a14fc5c-e29a-4fd8-90c4-e052748ff01c", "deleted": false }), |
VALUES ("f002", { "parent": "1496116023888_5a14fc5c-e29a-4fd8-90c4-e052748ff01c", "deleted": true, "abc": 1 }), |
VALUES ( "1496116023888_5a14fc5c-e29a-4fd8-90c4-e052748ff01c", { "metadata": { "published": 1496116023888}, "tag": { "expiryepoch": 1496202423888, "token": "c7468adf-ac8a-4551-a4fa-3b136f9d76ca" } }); |
CREATE INDEX ix1 ON default(tag.token, tag.expiryepoch, metadata.published, metadata.deleted); |
CREATE INDEX ix2 ON default(parent,abc); |
select 1 from default a JOIN default b ON KEY b.parent FOR a where a.tag.token = 'c7468adf-ac8a-4551-a4fa-3b136f9d76ca' and a.tag.expiryepoch > 1 and a.metadata.published > 1 and b.abc = 1; |
Above covered query can give 0 or 2 results. It should return one. non covered query gives 1 result.