MySQL Bugs: #79677: Optimizer performs a significantly wrong plan

Bug #79677	Optimizer performs a significantly wrong plan
Submitted:	16 Dec 2015 17:49	Modified:	17 Dec 2015 13:45
Reporter:	Saverio Miroddi	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S3 (Non-critical)
Version:	5.6.27, 5.6.28	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
With a certain set of data, the optimizer performs a significantly wrong plan.

With 5.6.24 and an essentially similar dataset, this wasn't happening, although it may be a coincidence.

How to repeat:
Load the data, and execute the query.

Hello Saverio M,

Thank you for the report and test case.
I'm not seeing much diff in 5.6.24, 5.6.28.
Verifying based on results from 5.5.48/5.7.10 when compared with 5.628.

Thanks,
Umesh