[wp-trac] Re: [WordPress Trac] #8949: WP creates duplicate options

[WordPress Trac]

#8949: WP creates duplicate options
-------------------------------+--------------------------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:  anonymous  
     Type:  defect (bug)       |      Status:  new        
 Priority:  low                |   Milestone:  2.9        
Component:  Optimization       |     Version:  2.7        
 Severity:  minor              |    Keywords:  needs-patch
-------------------------------+--------------------------------------------

Comment(by vladimir_kolesnikov):

 Replying to [comment:14 mrmist]:
 > Unfortunately ON DUPLICATE KEY UPDATE is MySQL 4.1.0 which is higher
 than the current requirements of WordPress.

 I hate to disappoint, but WordPress (at least 2.8) already uses ON
 DUPLICATE KEY UPDATE:

 {{{
 $wpdb->query("INSERT INTO $wpdb->term_relationships (object_id,
 term_taxonomy_id, term_order) VALUES " . join(',', $values) . " ON
 DUPLICATE KEY UPDATE term_order = VALUES(term_order)");
 }}}

 in /wp-includes/taxonomy.php, function wp_set_object_terms().

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