Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.5.0
-
4.5.0-1759
-
Untriaged
-
Unknown
Description
Query issued:
|
select name from default where any v in default.join_yr satisfies v = 2016 END AND (ANY x within default.VMs SATISFIES x.RAM between 1 and 5 END ) AND NOT (department = 'Manager') order by name limit 10;
|
|
Result:
|
[
|
{
|
"code": 5000,
|
"msg": "gob: type not registered for interface: []interface {} - cause: gob: type not registered for interface: []interface {}"
|
},
|
{
|
"code": 5000,
|
"msg": "gob: type not registered for interface: []interface {} - cause: gob: type not registered for interface: []interface {}"
|
}
|
]
|
|
Indexes created:
|
Definition: CREATE PRIMARY INDEX `#primary` ON `default` WITH({"index_type" : "forestdb"})
|
default 127.0.0.1:8091 idxVM Ready 100 %
|
Definition: CREATE INDEX `idxVM` ON `default`(`name`,(all (array (`x`.`RAM`) for `x` in `VMs` end)),`VMs`) WITH({"index_type" : "forestdb"})
|
default 127.0.0.1:8091 idxjoin_yr Ready 100 %
|
Definition: CREATE INDEX `idxjoin_yr` ON `default`(`department`,(distinct (array `v` for `v` in `join_yr` end)),`join_yr`,`name`) WITH({"index_type" : "forestdb"})
|
|
Dataset:
|
1 Bucket default with 1680 docs.
|
Each doc looks like:
|
{
|
"tasks": [
|
{
|
"Marketing": [
|
{
|
"region2": "International",
|
"region1": "North"
|
},
|
{
|
"region2": "North"
|
}
|
],
|
"Developer": [
|
"Storage",
|
"IOS"
|
]
|
},
|
"Sales",
|
"QA"
|
],
|
"name": [
|
{
|
"FirstName": "employeefirstname-4"
|
},
|
{
|
"MiddleName": "employeemiddlename-4"
|
},
|
{
|
"LastName": "employeelastname-4"
|
}
|
],
|
"address": [
|
[
|
{
|
"city": "Delhi"
|
},
|
{
|
"street": "21st street"
|
}
|
],
|
[
|
{
|
"country": "EUROPE",
|
"apartment": 123
|
}
|
]
|
],
|
"email": "4-mail@couchbase.com",
|
"mutated": 0,
|
"hobbies": {
|
"hobby": [
|
{
|
"sports": [
|
"American Football",
|
"Cricket",
|
"ski"
|
]
|
},
|
{
|
"dance": [
|
"bollywood",
|
"contemporary",
|
"hip hop"
|
]
|
},
|
"art"
|
]
|
},
|
"department": "Manager",
|
"join_yr": [
|
2011,
|
2012,
|
2016
|
],
|
"_id": "query-testemployee10194.855617-0",
|
"VMs": [
|
{
|
"RAM": 11,
|
"os": "ubuntu",
|
"name": "vm_11",
|
"memory": 11
|
},
|
{
|
"RAM": 11,
|
"os": "windows",
|
"name": "vm_12",
|
"memory": 11
|
},
|
{
|
"RAM": 11,
|
"os": "centos",
|
"name": "vm_13",
|
"memory": 11
|
},
|
{
|
"RAM": 11,
|
"os": "macos",
|
"name": "vm_14",
|
"memory": 11
|
}
|
]
|
}
|
|
|
Test which fails:
|
test_simple_array_index_all
|
Command to run the test:
|
./testrunner -i rqg1.ini -c conf/tuq/py-tuq-arrayindexing.conf -p doc-per-day=1
|
|
Uploading logs.
|