Bug #78355 nested select query not work on mysql 5.5 but it works well in mysql 5.6
Submitted: 7 Sep 2015 15:53 Modified: 15 Sep 2015 8:48
Reporter: Masood Afrashteh Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:5.5.41, 5.5.46, 5.5.47 OS:Ubuntu (x64)
Assigned to: CPU Architecture:Any
Tags: MySQL, performance, stored procedure, tsql

[7 Sep 2015 15:53] Masood Afrashteh
Description:
I have a nested select query and it's not work on mysql 5.5 but it work on mysql 5.6. 

How to repeat:
So I Bring up this issue (step by step) with attached pictures in stackexchange dba community and complete link is:
http://dba.stackexchange.com/questions/114256/why-select-work-in-mariadb-but-doesnt-work-i...
[8 Sep 2015 5:38] Umesh Shastry
Hello Masood Afrashteh,

Thank you for the report.
Could you please provide some subset of data(logical dump taken from mysqldump etc ) to reproduce this issue at our end? If required mark it as private when you upload.

Thanks,
Umesh
[15 Sep 2015 8:48] Umesh Shastry
Hello Masood Afrashteh,

Thank you for the report and test case.
Observed that 5.5.46/47 builds are affected.

Thanks,
Umesh