Re: Querying a fast subquery never returns
MariaDB 5.5 (released) has and MySQL 5.6.5 (not yet released) will have several significant optimization improvements. There is some overlap of what use cases they tackle well.
I have not heard that VIEWs are being improved. VIEWs are seen more as syntactic sugar, than as an important feature.
> found a related bug reported in 2007
Reference, please.
> this pervasive bug
"pervasive"?
> you can't trust MySQL being able to handle fairly simple queries.
Very true for subqueries. Usually converting to a JOIN is the solution. (Which is "simpler", a JOIN or a subquery?)
I will be happy to help you find workarounds, if you provide the requested information.
Subject
Views
Written By
Posted
2224
May 22, 2012 05:15PM
1268
May 22, 2012 05:19PM
1568
May 24, 2012 12:40AM
1517
May 25, 2012 11:15AM
Re: Querying a fast subquery never returns
1381
May 26, 2012 10:59AM
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.