Details
-
Improvement
-
Resolution: Fixed
-
Major
-
cbq-DP4, 4.0.0
-
Security Level: Public
-
None
Description
index is created on field VMs (it is an object)
cbq> EXPLAIN SELECT VMs FROM default WHERE ANY vm IN VMs SATISFIES vm.RAM > 5 AND vm.os = "ubuntu" end;
{
"request_id": "3d0baf37-70cf-49dd-bbc5-e4c167a5b8fb",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
}
],
"status": "success",
"metrics":
}
cbq>