Bug #106006 conditions are not pushed down into subqueries with union all: performance issue
Submitted: 30 Dec 2021 3:10 Modified: 11 Jan 2022 14:44
Reporter: Brian Yue (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:8.0.25, 8.0.27, 5.7.36 OS:Any (rhel-7.4)
Assigned to: CPU Architecture:Any (x86-64)
Tags: condition push down, performance, subqueries, tmp table, UNION ALL

Contributions can be accepted to Open bugs only.