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
• Status: No Feedback
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.7.5-m15
• OS: Linux (CentOS-6.5)
• 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] MySQL Verification Team

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".