• Leonard Zhou's avatar
    BUG#41719 delayed INSERT into timestamp col needs set time_zone for concurrent binlogging · 97c6e3f8
    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.
    97c6e3f8
rpl_timezone.test 5.03 KB