Bug #48819 Update a table with additional TIMESTAMP column on slave is wrong

• Submitted: 16 Nov 2009 20:11
• Modified: 7 Nov 2015 8:12
• Reporter: Serge Kozlov
• Status: Can't repeat
• Category: MySQL Server: Row Based Replication ( RBR )
• Severity: S3 (Non-critical)
• Version: 5.1-rep+3
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[16 Nov 2009 20:11] Serge Kozlov

Description:
Master and slave have different definiton for same table.
On master: CREATE TABLE t1 (a INT);
On slave:  CREATE TABLE t1 (a INT, b TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);

This configuration means that any update of the table on slave must write current time. In fact an updated row contains default value for this data type '0000-00-00 00:00:00'

How to repeat:
Use attached test case.

[16 Nov 2009 20:14] Serge Kozlov

test case

Attachment: bug48819.tgz (application/x-gzip, text), 405 bytes.

[29 Nov 2009 19:57] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/92012

364 Serge Kozlov	2009-11-29
      1. Test cases for bugs: bug#48815, bug#48819, bug#48845, bug#48903, bug#48908
      2. Added sorting test cases by their file names.
      3. Added test template Replication.pm
      added:
        lib/My/Nuts/Library/Tests/Replication.pm
        suites/bugs/
        suites/bugs/bug48815.pm
        suites/bugs/bug48819.pm
        suites/bugs/bug48845.pm
        suites/bugs/bug48903.pm
        suites/bugs/bug48908.pm
      modified:
        bin/Driver.pm

[28 Dec 2009 21:07] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/95765

365 Serge Kozlov	2009-12-29
      1. Test cases for bugs: bug#48815, bug#48819, bug#48845, bug#48903, bug#48908
      2. Added sorting test cases by their file names.
      3. Added test template Replication.pm
      added:
        lib/My/Nuts/Library/Tests/Replication.pm
        suites/bugs/
        suites/bugs/bug48815.pm
        suites/bugs/bug48819.pm
        suites/bugs/bug48845.pm
        suites/bugs/bug48903.pm
        suites/bugs/bug48908.pm
      modified:
        bin/Driver.pm