Bug #75679 This sql taks unusual long when execute in MySQL-5.7.5-m15
Submitted: 29 Jan 2015 11:01 Modified: 28 Feb 2015 11:09
Reporter: Niu Jason Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.7.5-m15 OS:Linux (CentOS-6.5)
Assigned to: CPU Architecture:Any

[29 Jan 2015 11:01] Niu Jason
Description:
select count(*)  from a_orders_child ordersChild where 1 = 1  and (ordersChild.name like '%%' or ordersChild.goodsthirdsn like '%%'  
or ordersChild.thirdsn like '%%' or ordersChild.note like '%%'  or ordersChild.orderid in 
(select id from a_orders_monther omon where omon.thirdsn like '%%' or omon.recename like '%%' ) ) 
and ordersChild.orderid in 
(select id from a_orders_monther omon where  (omon.status = 3 or omon.status = 4 )  
-- and (omon.outtype = 0 or omon.outtype = 1 or omon.outtype = 2) 
)

Uncomment the line and execute it in MySQL-5.7.5-m15,it takes very long to complete.And if then comment that line and run again,it complete very quickly.
But if the same sql run in MySQL-5.6 it behaves normal.The actual result has many records  with  “omon.outtype = 0”;

How to repeat:
Uncomment the line and execute it in MySQL-5.7.5-m15

Suggested fix:
NOt know
[29 Jan 2015 11:09] Miguel Solorzano
Thank you for the bug report. Please provide a complete test case (dump file with create and insert data). Thanks.
[1 Mar 2015 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".