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] MySQL Verification Team 
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] MySQL Verification Team 
Hello Masood Afrashteh,

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

Thanks,
Umesh

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.