[MDEV-9449] Optimizer regression in 10.1.9 Created: 2016-01-22 Updated: 2016-02-03 Resolved: 2016-02-01 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 10.1.9, 10.1 |
| Fix Version/s: | 10.1.11 |
| Type: | Bug | Priority: | Major |
| Reporter: | Will Fong | Assignee: | Sergei Petrunia |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
After the upgrade from 10.1.8 to 10.1.9 or 10.1.10, frequent queries involving index merge went crazy. Here is a repeatable test case :
10.1.8 :
10.1.9 :
|
| Comments |
| Comment by Elena Stepanova [ 2016-01-25 ] | |||||||||||||||||||||||||||||||||||||||||||||
|
The problem appeared in 10.1 tree with the following revision:
| |||||||||||||||||||||||||||||||||||||||||||||
| Comment by Sergei Petrunia [ 2016-02-01 ] | |||||||||||||||||||||||||||||||||||||||||||||
|
Need to check whether this is the same issue as in | |||||||||||||||||||||||||||||||||||||||||||||
| Comment by Sergei Petrunia [ 2016-02-01 ] | |||||||||||||||||||||||||||||||||||||||||||||
|
Indeed, no longer repeatable. Closing as duplicate of | |||||||||||||||||||||||||||||||||||||||||||||
| Comment by Elena Stepanova [ 2016-02-01 ] | |||||||||||||||||||||||||||||||||||||||||||||
|
Closing as fixed in scope of | |||||||||||||||||||||||||||||||||||||||||||||
| Comment by Sergei Petrunia [ 2016-02-03 ] | |||||||||||||||||||||||||||||||||||||||||||||
|
Just verified again: the behaviour changes back from index to index_merge when one applies patchj ff8d4009a7743b99c1c13831172b08041a4b272e, that is the fix for |