MySQL Bugs: #112198: Incorrect multiple equality optimization causes performance degradation

Bug #112198	Incorrect multiple equality optimization causes performance degradation
Submitted:	28 Aug 2023 8:21	Modified:	28 Aug 2023 8:32
Reporter:	Wen He (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S1 (Critical)
Version:	8.0, 8.0.34	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Contribution, equality, hash join, OUTER JOIN.

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

To submit contributions, please log in.

This is a fix for Bug #112198 by disabling field substitution for conditions other than equality, allowing predicate pushdown. (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: Bug#112198.patch (application/octet-stream, text), 4.00 KiB.