Bug #17842 | Statement pruning on UNION SELECT | ||
---|---|---|---|
Submitted: | 1 Mar 2006 21:42 | Modified: | 18 Aug 2007 2:07 |
Reporter: | Beat Vontobel (Silver Quality Contributor) (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S4 (Feature request) |
Version: | 5.0.18 | OS: | Any (any) |
Assigned to: | CPU Architecture: | Any | |
Tags: | qc |
[1 Mar 2006 21:42]
Beat Vontobel
[5 Mar 2006 9:14]
Valeriy Kravchuk
Thank you for a reasonable feature request. It would be nice for optimizer to check such a situations, at least, in obvious cases. Or just to perform outer conditions merge into UNIONed SELECTs before further optimization steps.
[18 Aug 2007 2:07]
Igor Babaev
- This is a request for an optimization implementation of which will take at least 2 man-month. - Yet the optimization does not look widely applied. By the above reasons I move the bug to 'To be fixed later'. Product management will decide in what version a fix for this problem appears.