Description
Is the query below no longer valid in 7.1? I see that it works in 7.x
I have a default bucket and travel-sample
CREATE PRIMARY INDEX ON default
CREATE INDEX id ON `travel-sample`(id)
SELECT *
FROM default d
INNER JOIN `travel-sample` t ON (t.id IN (DISTINCT ARRAY v.RAM FOR v IN d.VMs END))
[
{ "code": 3284, "msg": "ALL/DISTINCT is not allowed in (distinct (array (`v`.`RAM`) for `v` in (`d`.`VMs`) end)).", "query": "SELECT *\nFROM default d\nINNER JOIN `travel-sample` t ON (t.id IN (DISTINCT ARRAY v.RAM FOR v IN d.VMs END))" }]
In 7.0.x we see that this query works and returns results
EXPLAIN SELECT *
FROM default d
INNER JOIN `travel-sample` t ON (t.id IN (DISTINCT ARRAY v.RAM FOR v IN d.VMs END))
{
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "PrimaryScan3",
|
"as": "d",
|
"index": "#primary",
|
"index_projection": {
|
"primary_key": true
|
},
|
"keyspace": "default",
|
"namespace": "default",
|
"using": "gsi"
|
},
|
{
|
"#operator": "Fetch",
|
"as": "d",
|
"keyspace": "default",
|
"namespace": "default"
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "NestedLoopJoin",
|
"alias": "t",
|
"on_clause": "((`t`.`id`) in (distinct (array (`v`.`RAM`) for `v` in (`d`.`VMs`) end)))",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "IndexScan3",
|
"as": "t",
|
"has_dynamic_in": true,
|
"index": "id",
|
"index_id": "3d45b18547e1a1c2",
|
"index_projection": {
|
"primary_key": true
|
},
|
"keyspace": "travel-sample",
|
"namespace": "default",
|
"nested_loop": true,
|
"spans": [
|
{
|
"range": [
|
{
|
"dynamic_in": true,
|
"high": "array_max((distinct (array (`v`.`RAM`) for `v` in (`d`.`VMs`) end)))",
|
"inclusion": 3,
|
"low": "array_min((distinct (array (`v`.`RAM`) for `v` in (`d`.`VMs`) end)))"
|
}
|
]
|
}
|
],
|
"using": "gsi"
|
},
|
{
|
"#operator": "Fetch",
|
"as": "t",
|
"keyspace": "travel-sample",
|
"namespace": "default",
|
"nested_loop": true
|
}
|
]
|
}
|
},
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"expr": "self",
|
"star": true
|
}
|
]
|
}
|
]
|
}
|
}
|
]
|
}
|