|
INSERT INTO `default` ( KEY, VALUE ) VALUES( "id1A", { "type":"TYPEA", "subId":"id1", "valueA": [ { "cId" : "c1", "valueB": [ { "valueC": "testValueA" } ] }, { "cId" : "c2", "valueB": [ { "valueC": "testValueB" } ] } ] });
|
CREATE INDEX `ix20` ON `default` (
|
ALL (ARRAY (
|
ALL ( ARRAY var2.`valueC` FOR var2 IN var1.`valueB`
|
END))
|
FOR `var1` IN `valueA`
|
WHEN `var1`.`cId` = "c1" END), `subId`)
|
WHERE `type` = "TYPEA";
|
|
SELECT var2.valueC FROM default AS a
|
UNNEST a.valueA var1
|
UNNEST var1.valueB var2
|
WHERE a.type = "TYPEA"
|
AND var1.cId = "c1"
|
AND var2.valueC = "testValueA"
|
LIMIT 1;
|
Above query is covered , but there is no Cover around var1.cId also it is not there in FilterCovers
This result in wrong results