[wp-trac] Re: [WordPress Trac] #3681: Lack of forced GROUP BY or DISTINCT in query.php causes duplicate posts when plugins JOIN on wp_posts.ID = wp_post2cat.post_id

[WordPress Trac]

#3681: Lack of forced GROUP BY or DISTINCT in query.php causes duplicate posts
when plugins JOIN on wp_posts.ID = wp_post2cat.post_id
---------------------+------------------------------------------------------
 Reporter:  ajd777   |        Owner:  ryan   
     Type:  defect   |       Status:  closed 
 Priority:  normal   |    Milestone:         
Component:  General  |      Version:  2.1    
 Severity:  normal   |   Resolution:  wontfix
 Keywords:           |  
---------------------+------------------------------------------------------
Changes (by Nazgul):

  * priority:  high => normal
  * status:  new => closed
  * resolution:  => wontfix
  * severity:  major => normal
  * milestone:  2.1.1 =>

Comment:

 There is a limit to how far you should take backwards compatibility.

 I think I agree with Ryan that in this case the speed benefits outweigh
 the backwards compatibility issues.

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