MySQL Forums
Forum List  »  Optimizer & Parser

Re: running running running
Posted by: Øystein Grøvlen
Date: January 30, 2012 02:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
1808
January 30, 2012 03:16AM
Re: running running running
949
January 30, 2012 02:39AM
831
January 30, 2012 09:13AM
767
January 31, 2012 05:44AM
898
January 31, 2012 07:54AM
966
January 31, 2012 03:10AM
933
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.