Description
The following index has attribute d. If the query bucket aliased to same attribute name as d from now onwards it references as attribute.
If aliased as different name it references properly.
create index ix50 on default(p,d);
explain select d,q from default d where p = 5;
{
"requestID": "fb2476b5-a157-4bee-a5f1-fca3a3326b9c",
"signature": "json",
"results": [
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((`d`.`p`))",
"cover (`d`)",
"cover ((meta(`d`).`id`))"
],
"index": "ix50",
"index_id": "6a73b2e30794c969",
"keyspace": "default",
"namespace": "default",
"spans": [
{
"Range": {
"High": [
"successor(5)"
],
"Inclusion": 0,
"Low": [
"5",
"null"
]
}
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Filter",
"condition": "(cover ((`d`.`p`)) = 5)"
},
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "cover (`d`)"
},
{
"expr": "(cover (`d`).`q`)"
}
]
},
{
"#operator": "FinalProject"
}
]
}
}
]
},
"text": "select d,q from default d where p = 5;"
}
],
"status": "success",
"metrics": {
"elapsedTime": "3.533131ms",
"executionTime": "3.516633ms",
"resultCount": 1,
"resultSize": 2452
}
}
explain select d,q from default d1 where p = 5;
{
"requestID": "40fc8d38-e9bb-4cb4-8773-8a5436b58c85",
"signature": "json",
"results": [
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"index": "ix50",
"index_id": "6a73b2e30794c969",
"keyspace": "default",
"namespace": "default",
"spans": [
{
"Range": {
"High": [
"successor(5)"
],
"Inclusion": 1,
"Low": [
"5"
]
}
}
],
"using": "gsi"
},
{
"#operator": "Fetch",
"as": "d1",
"keyspace": "default",
"namespace": "default"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Filter",
"condition": "((`d1`.`p`) = 5)"
},
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "(`d1`.`d`)"
},
{
"expr": "(`d1`.`q`)"
}
]
},
{
"#operator": "FinalProject"
}
]
}
}
]
},
"text": "select d,q from default d1 where p = 5;"
}
],
"status": "success",
"metrics": {
"elapsedTime": "3.64641ms",
"executionTime": "3.62049ms",
"resultCount": 1,
"resultSize": 2401
}
}
Attachments
For Gerrit Dashboard: MB-22112 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
77669,6 | MB-22112 queries incorrectly planned as covered | master | query | Status: ABANDONED | +1 | 0 |
80340,3 | MB-22112 index testing framework changes | master | query | Status: MERGED | +2 | +1 |
80416,2 | MB-22112 fix gsi tests | master | query | Status: MERGED | +2 | +1 |
80453,2 | MB-22112 fix CoveredBy, add cover tests | master | query | Status: MERGED | +2 | +1 |
82114,3 | MB-25560 nested paths not covered if path length differs, MB-25561 meta does not cover | master | query | Status: MERGED | +2 | +1 |