MySQL Bugs: #103010: Subquery dependent on const tables gets evaluated for unnecessary multiple times

Bug #103010	Subquery dependent on const tables gets evaluated for unnecessary multiple times
Submitted:	17 Mar 2021 7:33	Modified:	17 Mar 2021 11:12
Reporter:	Hope Lee (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S5 (Performance)
Version:	8.0.23	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

To submit contributions, please log in.

The patch to optimize the server in this scenario. (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: 0001-Feature-Avoid-multiple-executions-of-subquery-depend.patch (application/octet-stream, text), 3.61 KiB.