MySQL Bugs: #115794: wrong plan may occur when EXISTS-subselect displays its correlated cache item

Bug #115794	wrong plan may occur when EXISTS-subselect displays its correlated cache item
Submitted:	8 Aug 2024 1:54	Modified:	8 Aug 2024 6:35
Reporter:	tianfeng li (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S3 (Non-critical)
Version:	8.0.30,8.4.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Contrbution

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

To submit contributions, please log in.

adjust Item_cache in Item_in_optimizer when performing substitution (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: 0001-When-an-EXISTS-subselect-creates-an-Item_cache-on-it.patch (application/octet-stream, text), 48.21 KiB.