Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.3
-
Untriaged
-
1
-
Unknown
Description
FYI: Works in 7.0.0
insert into default values ("car1",[ { "model": "bmw", "series": "x1" }, { "model": "renault", "series": "captur" }, { "model":"suzuki", "series":"vitara" } ] ); |
SELECT item.* FROM ['bmw', 'renault'] model INNER JOIN ARRAY_FLATTEN((SELECT RAW car FROM default car WHERE meta(car).id = 'car1'),1) item ON model = item.model; |
{
|
"requestID": "dbee168e-3570-4572-ab89-06f098c9e8a6", |
"signature": { |
"*": "*" |
},
|
"results": [ |
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "2.646726ms", |
"executionTime": "2.561986ms", |
"resultCount": 0, |
"resultSize": 0 |
}
|
}
|
cbq> SELECT item.* FROM ['bmw', 'renault'] model INNER JOIN ARRAY_FLATTEN((SELECT RAW car FROM default car WHERE meta(car).id = 'car1'),1) item USE NL ON model = item.model; |
{
|
"requestID": "cf795ee5-e429-4d94-a4a5-bc395af47d82", |
"signature": { |
"*": "*" |
},
|
"results": [ |
{
|
"model": "bmw", |
"series": "x1" |
},
|
{
|
"model": "renault", |
"series": "captur" |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "2.42608ms", |
"executionTime": "2.37998ms", |
"resultCount": 2, |
"resultSize": 116 |
}
|
}
|
https://forums.couchbase.com/t/processing-document-which-contains-array-of-objects/31211