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
2115
January 30, 2012 03:16AM
Re: running running running
1168
January 30, 2012 02:39AM
988
January 30, 2012 09:13AM
945
January 31, 2012 05:44AM
1076
January 31, 2012 07:54AM
1200
January 31, 2012 03:10AM
1153
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.