Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
5.0.0
-
5.0.0-1755
-
Untriaged
-
No
Description
- create bucket default with 82k similar docs.
- Execute this query:
SELECT meta().id, (SELECT RAW SUM(item.memory) FROM default as item)[0] total FROM orders LET items = (SELECT VMs.* FROM default.VMs ORDER BY VMs.memory)
- Above query takes 1 min to execute and returns results.
- Try changing the query in editor, I am not able to edit the query.The UI just hangs.
Example document:
{
"tasks": [
{
"Marketing": [
{
"region2": "International",
"region1": "South"
},
{
"region2": "South"
}
],
"Developer": [
"IOS",
"Indexing"
]
},
"Sales",
"QA"
],
"name": [
{
"FirstName": "employeefirstname-9"
},
{
"MiddleName": "employeemiddlename-9"
},
{
"LastName": "employeelastname-9"
}
],
"address": [
[
{
"city": "Delhi"
},
{
"street": "12th street"
}
],
[
{
"country": "EUROPE",
"apartment": 123
}
]
],
"email": "9-mail@couchbase.com",
"mutated": 0,
"hobbies": {
"hobby": [
{
"sports": [
"Badminton",
"Football",
"Basketball"
]
},
{
"dance": [
"hip hop",
"bollywood",
"contemporary"
]
},
"art"
]
},
"department": "Support",
"join_yr": [
2013,
2015,
2012
],
"_id": "query-testemployee10153.1877827-0",
"VMs": [
{
"RAM": 10,
"os": "ubuntu",
"name": "vm_10",
"memory": 10
},
{
"RAM": 10,
"os": "windows",
"name": "vm_11",
"memory": 10
},
{
"RAM": 10,
"os": "centos",
"name": "vm_12",
"memory": 10
},
{
"RAM": 10,
"os": "macos",
"name": "vm_13",
"memory": 10
}
]
}