[MDEV-10783] Server crashes in pushdown_cond_for_derived Created: 2016-09-09 Updated: 2016-09-23 Resolved: 2016-09-23 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 10.2 |
| Fix Version/s: | 10.2.2 |
| Type: | Bug | Priority: | Major |
| Reporter: | Elena Stepanova | Assignee: | Igor Babaev |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | regression-10.2 | ||
| Description |
|
The problem started happening after recent merges, but I can't point at the exact commit which caused it. |
| Comments |
| Comment by Oleksandr Byelkin [ 2016-09-11 ] |
|
It looks like problem with connecting SELECTs/UNITs. For now it meet upper SELECT without JOIN. Taking into account how SELECTs optimizing it should not be possible... |
| Comment by Oleksandr Byelkin [ 2016-09-11 ] |
|
Structure is correct. and it is pushing down. and it trying to push in SELECT which has no JOIN... (SELECT is simple maybe just removed or materialized?) |
| Comment by Oleksandr Byelkin [ 2016-09-11 ] |
|
The view is already materialized and cleaned up, that is why it is has no JOIN and that is why it is too late something pushdown in it. |
| Comment by Oleksandr Byelkin [ 2016-09-11 ] |
|
will discuss with igor how better to detect situation. |
| Comment by Igor Babaev [ 2016-09-23 ] |
|
The fix for this bug was pushed into the 10.2 tree. |