• Rohit Kalhans's avatar
    BUG#11765650 - 58637: MARK UPDATES THAT DEPEND ON ORDER OF TWO KEYS UNSAFE · fe935245
    Rohit Kalhans authored
          
     Description: When the table has more than one unique or primary key, 
     INSERT... ON DUP KEY UPDATE statement is sensitive to the order in which
     the storage engines checks the keys. Depending on this order, the storage
     engine may determine different rows to mysql, and hence mysql can update
     different rows on master and slave.
          
     Solution: We mark INSERT...ON DUP KEY UPDATE on a table with more than on unique
     key as unsafe therefore the event will be logged in row format if it is available
     (ROW/MIXED). If only STATEMENT format is available, a warning will be thrown. 
    fe935245
binlog_unsafe.test 25.5 KB