• Leonard Zhou's avatar
    BUG#41719 delayed INSERT into timestamp col needs set time_zone for concurrent binlogging · 5fdc5510
    Leonard Zhou authored
    When do 'insert delayed' operation, the time_zone info doesn't be keeped in the row info.
    So when we do insert sometime later, time_zone didn't write into binlog.
    This will cause wrong result for timestamp column in slave.
    
    Our solution is that adding time_zone info with the delayed-row and
    restoring time_zone from row-info when execute that row in the furture by another thread.
    So we can write correct time_zone info into binlog and got correct result in slave.
    
    
    mysql-test/r/rpl_timezone.result:
      Test result
    mysql-test/t/rpl_timezone.test:
      Add test for bug#41719
    sql/sql_insert.cc:
      Add time_zone info in the delayed-row and restore time_zone when execute the row in the furture by another thread.
    5fdc5510
rpl_timezone.test 5.03 KB