Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #22196, comment 7


Ignore:
Timestamp:
07/20/2017 09:08:23 AM (5 years ago)
Author:
donpark
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #22196, comment 7

    initial v1  
    22https://stackoverflow.com/questions/16377932/mysql-behavior-of-on-duplicate-key-update-for-multiple-unique-fields
    33Duplicate keys are matched with OR, not AND, which makes no sense to me.
    4 Undefined behavior stems for undefined order of duplicate key matching rows.
     4Undefined behavior stems from undefined order of duplicate key matching rows.
    55
    66In short, UPSERT on MySQL needs to be used with care. Frankly I think this may be too much to ask for from typical WP hackers, even with flashing warning message.