[MDEV-22665] Print ranges in the optimizer trace created for non-indexed columns when optimizer_use_condition_selectivity >2 Created: 2020-05-22 Updated: 2020-07-02 Resolved: 2020-06-19 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 10.4, 10.5 |
| Fix Version/s: | 10.4.14, 10.5.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Varun Gupta (Inactive) | Assignee: | Varun Gupta (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | optimizer_trace | ||
| Description |
|
For non-indexed columns ranges are created when optimizer_use_condition_selectivity > 2 and with the help of EITS we are able to make estimates for predicates which involved non-indexed columns. Eg:
If there is no index on column a we will create a range for a=10 and get the statistics from EITS. It would be good to print this range in the optimizer trace too. |
| Comments |
| Comment by Varun Gupta (Inactive) [ 2020-05-26 ] |
|
Patch |
| Comment by Sergei Petrunia [ 2020-06-17 ] |
|
Review input provided over email. Ok to push when addressed. |