[wp-trac] Re: [WordPress Trac] #5137: Taxonomy intersection queries are inefficient

[WordPress Trac]

#5137: Taxonomy intersection queries are inefficient
----------------------------------+-----------------------------------------
 Reporter:  ryan                  |        Owner:  anonymous
     Type:  defect                |       Status:  reopened 
 Priority:  normal                |    Milestone:  2.3.1    
Component:  General               |      Version:  2.3      
 Severity:  normal                |   Resolution:           
 Keywords:  taxonomy performance  |  
----------------------------------+-----------------------------------------
Comment (by DD32):

 > You end up with no spaces between the ) and the WHERE or the ) and the
 GROUP. The query should fail unless MySQL is a lot smarter than any other
 database I've ever used.

 MySQL must be smarter than any other database you've used then. MySQL
 handles that SQL perfectly (It doesnt need the space between the bracket
 and WHERE/GROUP statement; If the brackets were left out of that statement
 however, MySQL wouldnt handle too well).

 Mind you, I would suggest that the spaces be added at least for those who
 want to try and use other databases, as they're probably not as forgiving.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/5137#comment:7>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software