[wp-trac] [WordPress Trac] #17582: Problems with duplicated users

WordPress Trac wp-trac at lists.automattic.com
Tue Jun 7 16:58:37 UTC 2011


#17582: Problems with duplicated users
--------------------------+---------------------
 Reporter:  scribu        |       Owner:  ryan
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  3.2
Component:  Query         |     Version:
 Severity:  normal        |  Resolution:  fixed
 Keywords:  has-patch     |
--------------------------+---------------------

Comment (by Denis-de-Bernardy):

 Curious to know why a group by wasn't used, instead of a distinct.

 The distinct will cause the data to be sort by all fields in their select
 order, at which point dupe are eliminated.

 If we were to append the order by clause with the ID and then group by and
 order by the latter, by contrast, we'd eliminate the dups without needing
 to re-order at all.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17582#comment:28>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list