Details
Description
With GSI
./testrunner -i centos.ini -t 2i.indexscans_2i.SecondaryIndexingScanTests.test_multi_create_query_explain_drop_index_scan_consistency,groups=simple:notequals,dataset=default,doc-per-day=10,use_gsi_for_primary=True,use_gsi_for_secondary=True,scan_consistency=request_plus,skip_cleanup=True,nodes_init=4,services_init=n1ql:kv-kv-index-index,skip_cleanup=True,run_drop_index=False
Scenario Description with GSI index
1. Create 4 node cluster (1: n1ql,kv 2: kv 3: index 4: index)
2. Create Default bucket with 20160 items for Employee dataset
3. Create PRIMARY INDEX using gsi, Wait till it comes online
4. Create GSI INDEX for field job_title, wait till it comes online
5. Run Query: SELECT * FROM default WHERE job_title != "Sales" ORDER BY _id
query Results are incorrect.Actual num 13317. Expected num: 13440
As seen from CBQ
cbq> EXPLAIN SELECT count FROM default WHERE job_title != "Engineer" ORDER BY _id ;
{
"requestID": "3043d8ae-72ca-452d-b095-1713c168ce59",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "UnionScan",
"scans": [
{
"#operator": "IndexScan",
"index": "employeeb73ebdd6af954d5b8264cae23724572ejob_title",
"keyspace": "default",
"limit": 9.223372036854776e+18,
"namespace": "default",
"spans": [
{
"Range":
,
"Seek": null
},
{
"Range":
,
"Seek": null
}
],
"using": "gsi"
}
]
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{ "#operator": "InitialGroup", "aggregates": [ "count(*)" ], "group_keys": [] } ]
}
},
,
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
]
}
]
}
}
]
},
{
"#operator": "Order",
"sort_terms": [
]
},
{
"#operator": "Parallel",
"~child":
}
]
}
],
"status": "success",
"metrics":
}
cbq> SELECT count FROM default WHERE job_title != "Engineer" ORDER BY _id ;
{
"requestID": "16a730ed-8234-4077-ba18-0418a6e03d75",
"signature":
,
"results": [
],
"status": "success",
"metrics":
}
cbq>
Attachments
For Gerrit Dashboard: MB-14102 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
48733,3 | Fix boundary issues in scan_union and scan_intersect. Fix race conditions when scanning IN and OR and != queries. Change-Id: Ib9cc57f8ec42fa4e70e38abd93cff88df22d9212 | master | query | Status: MERGED | +2 | +1 |