MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Query works in 5.5 but not 5.6
Posted by: Peter Brawley
Date: October 10, 2013 08:27AM

The likely reason for different results for that query in 5.5 and 5,6 is data.

The query will likely perform better if IN(SELECT...) is turned into a JOIN.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Query works in 5.5 but not 5.6
Anthony Tso
October 10, 2013 03:59AM
Re: Query works in 5.5 but not 5.6
Peter Brawley
October 10, 2013 08:27AM
Re: Query works in 5.5 but not 5.6
Anthony Tso
October 10, 2013 09:05PM
Re: Query works in 5.5 but not 5.6
Peter Brawley
October 11, 2013 11:57AM
Re: Query works in 5.5 but not 5.6
Anthony Tso
October 11, 2013 03:52PM
Re: Query works in 5.5 but not 5.6
Peter Brawley
October 13, 2013 08:54AM
Re: Query works in 5.5 but not 5.6
Anthony Tso
October 13, 2013 03:25PM
Re: Query works in 5.5 but not 5.6
Peter Brawley
October 13, 2013 10:14PM
Re: Query works in 5.5 but not 5.6
Anthony Tso
October 13, 2013 11:35PM
Re: Query works in 5.5 but not 5.6
Peter Brawley
October 14, 2013 08:33AM
Re: Query works in 5.5 but not 5.6
Anthony Tso
October 14, 2013 02:30PM
Re: Query works in 5.5 but not 5.6
Peter Brawley
October 15, 2013 12:45AM


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.