MySQL Bugs: #101855: SELECT DISTINCT returns wrong results if not_used_in

Bug #101855	SELECT DISTINCT returns wrong results if not_used_in_distinct and use JOIN CACHE
Submitted:	3 Dec 2020 11:43	Modified:	4 Dec 2020 15:33
Reporter:	Hope Lee (OCA)	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S2 (Serious)
Version:	8.0.13	OS:	CentOS
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Contributions can be accepted to Open bugs only.

SELECT DISTINCT returns wrong results when JOIN enumeration shortcut

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: 0001-Bugfix-SELECT-DISTINCT-returns-wrong-results-when-JO.patch (application/octet-stream, text), 3.92 KiB.