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
}
}