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

[WordPress Trac]

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

Comment (by greuben):

 > In future it would be really useful to include the explain output on the
 ticket so that anyone reviewing the patch can see it.
 Sorry, here it is

 17582.2.diff
 {{{
 +----+-------------+-------------+------+------------------+---------+---------+-----------------+------+---------------------------------+
 | id | select_type | table       | type | possible_keys    | key     |
 key_len | ref             | rows | Extra                           |
 +----+-------------+-------------+------+------------------+---------+---------+-----------------+------+---------------------------------+
 |  1 | SIMPLE      | wp_users    | ALL  | PRIMARY          | NULL    |
 NULL    | NULL            |    2 | Using temporary; Using filesort |
 |  1 | SIMPLE      | wp_usermeta | ref  | user_id,meta_key | user_id | 8
 | dev.wp_users.ID |    7 | Distinct                        |
 |  1 | SIMPLE      | mt1         | ref  | user_id,meta_key | user_id | 8
 | dev.wp_users.ID |    7 | Using where; Distinct           |
 +----+-------------+-------------+------+------------------+---------+---------+-----------------+------+---------------------------------+
 }}}

 17582.3.diff
 {{{
 +----+-------------+-------------+------+------------------+---------+---------+-----------------+------+---------------------------------+
 | id | select_type | table       | type | possible_keys    | key     |
 key_len | ref             | rows | Extra                           |
 +----+-------------+-------------+------+------------------+---------+---------+-----------------+------+---------------------------------+
 |  1 | SIMPLE      | wp_users    | ALL  | PRIMARY          | NULL    |
 NULL    | NULL            |    2 | Using temporary; Using filesort |
 |  1 | SIMPLE      | wp_usermeta | ref  | user_id,meta_key | user_id | 8
 | dev.wp_users.ID |    7 |                                 |
 |  1 | SIMPLE      | mt1         | ref  | user_id,meta_key | user_id | 8
 | dev.wp_users.ID |    7 | Using where                     |
 +----+-------------+-------------+------+------------------+---------+---------+-----------------+------+---------------------------------+
 }}}

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