MySQL Bugs: #117776: Index statistics is unexpectedly used to estimate eq ranges with null part

Bug #117776	Index statistics is unexpectedly used to estimate eq ranges with null part
Submitted:	24 Mar 5:01	Modified:	24 Mar 7:46
Reporter:	Kaiwang CHen (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S3 (Non-critical)
Version:	8.0, 8.4, 9.2	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Contribution

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

To submit contributions, please log in.

Reinterprete NULL_RANGE for range estimation as the range has at least one null part "kp_i IS NULL" (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: bug_117776.patch (application/octet-stream, text), 14.17 KiB.