Description
create index i3 on `beer-sample`(meta().id, city);
explain select city from `beer-sample` where meta().id >= "M" limit 10; This LIMIT isn’t pushed to index scan. If I create index on other fields city/etc alone, that LIMIT gets pushed down.
[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((meta(`beer-sample`).`id`))",
"cover ((`beer-sample`.`city`))",
"cover ((meta(`beer-sample`).`id`))"
],
"index": "i3",
"index_id": "b21159b6dc4e192",
"keyspace": "beer-sample",
"namespace": "default",
"spans": [
{
"Range":
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
]
},
"text": "select city from `beer-sample` where meta().id >= \"M\" limit 10;"
}
]
Attachments
For Gerrit Dashboard: MB-18936 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
62127,2 | MB-18936 LIMIT is not pushed down on indices with leading key as meta().id. | master | query | Status: MERGED | +2 | +1 |