Details
-
Bug
-
Resolution: Fixed
-
Critical
-
7.1.0
-
Untriaged
-
1
-
Unknown
Description
Adapted from unit test case flattenkeys at test/gsi/test_cases/flattenkeys.
CREATE INDEX `ixf10n` ON `orders`.`_default`.`flattenkeys`(`isbn`,`author` DESC,(distinct (array (distinct (array flatten_keys((`pg`.`num`) DESC, (`pg`.`name`) DESC, (`ch`.`description`)) for `pg` in (`ch`.`pages`) end)) for `ch` in `chapters` end)),`year`,`name`) WHERE (`type` = "book"); |
insert the 3 documents with insert.json.
Query:
explain SELECT META(f).id, f.isbn, f.author, f.year FROM flattenkeys AS f WHERE f.type = 'book' AND ANY ch IN f.chapters SATISFIES (ANY AND EVERY pg IN ch.pages SATISFIES pg.num = 1 AND pg.name = 'page 1' AND ch.description LIKE 'chapter 1 %' END) END AND f.isbn >= 1 AND f. year >= 2020 ORDER BY f.isbn, f.author DESC, f.year LIMIT 5; |
Server enters an infinite loop and exit when run out of memory.