• unknown's avatar
    Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR · b84e9d10
    unknown authored
    Fix tests for new behaviour: an error is thrown if a NON DETERMINISTIC
    stored function (SF) is called during statement-based replication (SBR).
    
    
    mysql-test/r/func_time.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/r/gis.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Mark function as DETERMINISTIC so it can be called with no error while
      doing statement-based replication (SBR).
    mysql-test/r/grant2.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/r/innodb_notembedded.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/r/ps.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Mark function as DETERMINISTIC so it can be called with no error while
      doing statement-based replication (SBR).
    mysql-test/r/query_cache.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/r/query_cache_notembedded.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/r/rpl_sp.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Move test for SF-calls in different replication modes to its own file, rpl_sf.
    mysql-test/r/rpl_sp_effects.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/r/sp.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Mark function as DETERMINISTIC so it can be called with no error while
      doing statement-based replication (SBR).
    mysql-test/r/timezone2.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/func_time.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/gis.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Mark function as DETERMINISTIC so it can be called with no error while
      doing statement-based replication (SBR).
    mysql-test/t/grant2.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/innodb_notembedded.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/ps.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/query_cache.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/query_cache_notembedded.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/rpl_sp.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/rpl_sp_effects.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    mysql-test/t/sp.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Mark function as DETERMINISTIC so it can be called with no error while
      doing statement-based replication (SBR).
    mysql-test/t/timezone2.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Modify test that contains non-deterministic functions so it can still be
      called with no error while doing statement-based replication (SBR).
    sql/item_func.cc:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      If 'log_bin_trust_function_creators' variable is set, don't throw an error
      on calling a non-deterministc function in statement-based replication (SBR).
    sql/sql_parse.cc:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Do not throw an error on calling a NON DETERMINISTIC stored procedure (SP)
      while doing statement-based replication (SBR), as the routine body is
      executed statement-by-statement.
    mysql-test/r/rpl_sf.result:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Test for stored function (SF) calls in different replication modes.
      NON DETERMINISTIC SFs are not allowed while doing
      statement-based replication (SBR).
    mysql-test/t/rpl_sf.test:
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
      
      Test for stored function (SF) calls in different replication modes.
      NON DETERMINISTIC SFs are not allowed while doing
      statement-based replication (SBR).
    b84e9d10
timezone2.test 8.08 KB