[wp-trac] Re: [WordPress Trac] #2709: Category query cleanups

[WordPress Trac]

#2709: Category query cleanups
----------------------------+-----------------------------------------------
       Id:  2709            |      Status:  new                     
Component:  Administration  |    Modified:  Sat May  6 22:57:24 2006
 Severity:  major           |   Milestone:  2.1                     
 Priority:  high            |     Version:  2.0.2                   
    Owner:  skeltoac        |    Reporter:  skeltoac                
----------------------------+-----------------------------------------------
Comment (by skeltoac):

 Due to the JOIN, NOT IN can fail in this circumstance: a post is in two
 categories, one of which is not in the NOT IN list. The usual case here is
 that a post is in categores "Parent" and "Child", and the excluded
 category is "Child." In this case, the post will appear because the JOIN
 returns a row with the the category_id of Parent, which is not an excluded
 category.

 I think this is acceptable. Any argument?

-- 
Ticket URL: <http://trac.wordpress.org/ticket/2709>
WordPress Trac <http://wordpress.org/>
WordPress blogging software