[wp-trac] [WordPress Trac] #11649: Upgrades Fail Because of [11883]

[WordPress Trac]

#11649: Upgrades Fail Because of [11883]
-----------------------------+----------------------------------------------
 Reporter:  miqrogroove      |       Owner:           
     Type:  defect (bug)     |      Status:  new      
 Priority:  normal           |   Milestone:  2.9.1    
Component:  Upgrade/Install  |     Version:  2.9      
 Severity:  blocker          |    Keywords:  has-patch
-----------------------------+----------------------------------------------

Comment(by mrmist):

 If you really wanted a duplicate check before the delete, you could use
 something like

 select min(option_id) from wp_de_options
 group by option_name
 having count(*) >1

 Which may turn out more efficient than the joining method.  Would also
 allow grouping by blog_id if that column is actuall used anywhere..

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