Re: running running running
Hi,
This sounds like a bug. Please, report it at bugs.mysql.com.
Since EXPLAIN never finishes, it seems to be stuck in optimization phase. The query contains only left/right joins and no inner joins, so the join sequence is predetermined, and optimization should not take long.
By the way, I think the query would be easier to read and understand if it was rewritten to use only left joins and no right joins.
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
2219
January 30, 2012 03:16AM
Re: running running running
1226
January 30, 2012 02:39AM
1013
January 30, 2012 09:13AM
1000
January 31, 2012 05:44AM
1110
January 31, 2012 07:54AM
1233
January 31, 2012 03:10AM
1189
January 31, 2012 05:00PM
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.