• unknown's avatar
    Backport Bug #45827 Stmt using two autoinc values does not produce unsafe warning · 0d46e588
    unknown authored
          
    One statement that have more than one different tables to update with 
    autoinc columns just was marked as unsafe in mixed mode, so the unsafe 
    warning can't be produced in statement mode.
          
    To fix the problem, mark the statement as unsafe in statement mode too.
    
    
    mysql-test/extra/rpl_tests/rpl_insert_id.test:
      The test case is updated due to the patch of bug#45827.
    mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result:
      The test result is updated due to the patch of bug#45827.
    mysql-test/suite/binlog/r/binlog_unsafe.result:
      Test result for bug#45827.
    mysql-test/suite/binlog/t/binlog_unsafe.test:
      Added test to verify if stmt that have more than one
      different tables to update with autoinc columns will 
      produce unsafe warning
    mysql-test/suite/rpl/r/rpl_stm_auto_increment_bug33029.result:
      The test result is updated due to the patch of bug#45827.
    mysql-test/suite/rpl/t/rpl_trigger.test:
      The test case is updated due to the patch of bug#45827.
    mysql-test/suite/rpl/t/rpl_variables_stm.test:
      The test case is updated due to the patch of bug#45827.
    sql/sql_base.cc:
      Reomved the 'set_current_stmt_binlog_row_based_if_mixed' function 
      for producing unsafe warnings by executing 'decide_logging_format' 
      function later in statement mode
    0d46e588
rpl_trigger.test 11.6 KB