Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
4.0.0
-
Security Level: Public
-
ran the issue on the latest build. 1 node only, check for n_0 logs.
-
Untriaged
-
Yes
-
ForestDB: Oct 26 - Nov 13
Description
./testrunner -i test.ini -t 2i.indexscans_2i.SecondaryIndexingScanTests.test_multi_create_query_explain_drop_index,groups=simple:greater_than:no_orderby_groupby:range,dataset=default,doc-per-day=1,use_gsi_for_primary=True,use_gsi_for_secondary=True,skip_cleanup=True
1. Create 1 node cluster with all services
2. Add default bucket with 2016 items for employee data set
3. Create GSI index on a field "join_yr"
4. query using select * from default where join_yr > 1999
Step 4 returns empty result set
Sample:
{
"tasks_points":
,
"name": "employee-9",
"mutated": 0,
"skills": [
"skill2010",
"skill2011"
],
"join_day": 9,
"join_mo": 10,
"email": "9-mail@couchbase.com",
"test_rate": 10.1,
"join_yr": 2011,
"_id": "query-testemployee10153.1877827-0",
"VMs": [
,
{ "RAM": 10, "os": "windows", "name": "vm_11", "memory": 10 } ],
"job_title": "Engineer"
}