MySQL Forums
Forum List  »  Optimizer & Parser

running running running
Posted by: paolo tome
Date: January 30, 2012 03:16AM

Hello everyone!
I hope that someone wants to share with me a funny query whose behavior is unnerve me for several days.

Link to the query (www.edulink.uniud.it/query.sql) and db with the main tables (www.edulink.uniud.it/diagramma-db.pdf)
the thing that eludes me is why the query stops working (it runs indefinitely without giving results or errors - EXPLAIN also has the same behavior) if there are WHERE conditions among the fields of the last table (t_reperto_micro) .....

anyone can give me some suggestions?

I thank anyone who can help me!

Paolo

Options: ReplyQuote


Subject
Views
Written By
Posted
running running running
2251
January 30, 2012 03:16AM
1250
January 30, 2012 02:39AM
1035
January 30, 2012 09:13AM
1020
January 31, 2012 05:44AM
1130
January 31, 2012 07:54AM
1261
January 31, 2012 03:10AM
1216
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.