Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.6.3, 5.0.0, 5.5.0
-
Untriaged
-
Unknown
Description
CREATE INDEX `IX_reporting_visits_name_Person` ON `default`((distinct (array (`vs1`.`departmentCode`) for `vs1` in `visits` end)),`visits`,`firstName`,`lastName`) WHERE (`type` = "Person") ; |
explain select visits from default where type = 'Person' and meta().id not like '_sync%' and any v in visits satisfies v.departmentCode = 'HS' and Date_format_str(v.startDate, '1111-11-11') = '2018-01-30' END ; |
{
|
"requestID": "aea8c31d-3e5f-45bb-b476-0d98ffa04089", |
"signature": "json", |
"results": [ |
{
|
"plan": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "DistinctScan", |
"scan": { |
"#operator": "IndexScan3", |
"covers": [ |
"cover ((distinct (array (`vs1`.`departmentCode`) for `vs1` in (`default`.`visits`) end)))", |
"cover ((`default`.`visits`))", |
"cover ((`default`.`firstName`))", |
"cover ((`default`.`lastName`))", |
"cover ((meta(`default`).`id`))" |
],
|
"filter_covers": { |
"cover ((`default`.`type`))": "Person", |
"cover (any `v` in (`default`.`visits`) satisfies (((`v`.`departmentCode`) = \"HS\") and (date_format_str((`v`.`startDate`), \"1111-11-11\") = \"2018-01-30\")) end)": true |
},
|
"index": "IX_reporting_visits_name_Person", |
"index_id": "df8b11b171935cf", |
"index_projection": { |
"entry_keys": [ |
1 |
],
|
"primary_key": true |
},
|
"keyspace": "default", |
"namespace": "default", |
"spans": [ |
{
|
"exact": true, |
"range": [ |
{
|
"high": "\"HS\"", |
"inclusion": 3, |
"low": "\"HS\"" |
}
|
]
|
}
|
],
|
"using": "gsi" |
}
|
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "Filter", |
"condition": "(((cover ((`default`.`type`)) = \"Person\") and (not (cover ((meta(`default`).`id`)) like \"_sync%\"))) and cover (any `v` in (`default`.`visits`) satisfies (((`v`.`departmentCode`) = \"HS\") and (date_format_str((`v`.`startDate`), \"1111-11-11\") = \"2018-01-30\")) end))" |
},
|
{
|
"#operator": "InitialProject", |
"result_terms": [ |
{
|
"expr": "cover ((`default`.`visits`))" |
}
|
]
|
},
|
{
|
"#operator": "FinalProject" |
}
|
]
|
}
|
}
|
]
|
},
|
"text": "select visits from default where type = 'Person' and meta().id not like '_sync%' and any v in visits satisfies v.departmentCode = 'HS' and Date_format_str(v.startDate, '1111-11-11') = '2018-01-30' END;" |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "3.529461ms", |
"executionTime": "3.505716ms", |
"resultCount": 1, |
"resultSize": 3718 |
}
|
}
|
Filter cover should not have contain "cover (any `v` in (`default`.`visits`) satisfies (((`v`.`departmentCode`) = \"HS\") and (date_format_str((`v`.`startDate`), \"1111-11-11\") = \"2018-01-30\")) end)": true because predicate not pushed to spans as exact.
Attachments
Issue Links
| For Gerrit Dashboard: MB-27815 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 92865,3 | MB-27815 Consider Array index filter covers, when pushed to indexer | master | query | Status: MERGED | +2 | +1 |
| 92979,2 | MB-27815 Consider Array index filter covers, when pushed to indexer | spock | query | Status: MERGED | +2 | +1 |
| 93455,2 | MB-27815. Fix panic | spock | query | Status: MERGED | +2 | +1 |
| 93632,6 | 5.1.1 bug automation for MB-28175/MB-29034/MB-27815 CBQE-4613 | spock | testrunner | Status: MERGED | +2 | +1 |