Re: Query works in 5.5 but not 5.6
Well, I don't know why you insist on reading value_id as value, but I know what I am reading.
Anyway this is the response from mysql on my bug report.
"This is confirmed to be a problem with an IF predicate in the WHERE
clause combined with OUTER JOIN in a subquery that is transformed to a
semi-join.
A workaround is to disable semi-join for this query:
set optimizer_switch='semijoin=off';"
Subject
Written By
Posted
Re: Query works in 5.5 but not 5.6
October 14, 2013 02:30PM
Sorry, you can't reply to this topic. It has been closed.
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.