• sven@riska.(none)'s avatar
    BUG#31168: @@hostname does not replicate · 81b1d712
    sven@riska.(none) authored
    Problem: in mixed and statement mode, a query that refers to a
    system variable will use the slave's value when replayed on
    slave. So if the value of a system variable is inserted into a
    table, the slave will differ from the master.
    Fix: mark statements that refer to a system variable as "unsafe",
    meaning they will be replicated by row in mixed mode and produce a warning
    in statement mode. There are some exceptions: some variables are actually
    replicated. Those should *not* be marked as unsafe.
    BUG#34732: mysqlbinlog does not print default values for auto_increment variables
    Problem: mysqlbinlog does not print default values for some variables,
    including auto_increment_increment and others. So if a client executing
    the output of mysqlbinlog has different default values, replication will
    be wrong.
    Fix: Always print default values for all variables that are replicated.
    I need to fix the two bugs at the same time, because the test cases would
    fail if I only fixed one of them.
    81b1d712
commit_1innodb.result 18.9 KB