diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_switch_stm_row_mixed.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_switch_stm_row_mixed.result | 36 |
1 files changed, 34 insertions, 2 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_switch_stm_row_mixed.result b/mysql-test/suite/rpl/r/rpl_switch_stm_row_mixed.result index 7fcb0601ebf..2f7f1b07cb4 100644 --- a/mysql-test/suite/rpl/r/rpl_switch_stm_row_mixed.result +++ b/mysql-test/suite/rpl/r/rpl_switch_stm_row_mixed.result @@ -1,5 +1,7 @@ include/master-slave.inc [connection master] +connection slave; +connection master; drop database if exists mysqltest1; create database mysqltest1; use mysqltest1; @@ -19,7 +21,7 @@ binlog_format ROW set global binlog_format=DEFAULT; show global variables like "binlog_format%"; Variable_name Value -binlog_format STATEMENT +binlog_format MIXED set global binlog_format=MIXED; show global variables like "binlog_format%"; Variable_name Value @@ -133,11 +135,13 @@ insert into t1 values(concat("for_23_",UUID())); insert into t1 select "yesterday_24_"; create table t2 ENGINE=MyISAM select rpad(UUID(),100,' '); create table t3 select 1 union select UUID(); +SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR create table t4 select * from t1 where 3 in (select 1 union select 2 union select UUID() union select 3); +SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR create table t5 select * from t1 where 3 in (select 1 union select 2 union select curdate() union select 3); Warnings: Warning 1292 Incorrect datetime value: '3' -insert into t5 select UUID() from t1 where 3 in (select 1 union select 2 union select 3 union select * from t4); +insert ignore into t5 select UUID() from t1 where 3 in (select 1 union select 2 union select 3 union select * from t4); create procedure foo() begin insert into t1 values("work_25_"); @@ -255,6 +259,8 @@ insert delayed into t2 values("delay_6_"); insert delayed into t2 values(rand()); set @a=2.345; insert delayed into t2 values(@a); +connection slave; +connection master; create table t20 select * from t1; create table t21 select * from t2; create table t22 select * from t3; @@ -271,14 +277,18 @@ end| select f("try_41_"); f("try_41_") 1 +connection slave; use mysqltest1; insert into t2 values(2,null),(3,null),(4,null); delete from t2 where a>=2; +connection master; select f("try_42_"); f("try_42_") 1 +connection slave; insert into t2 values(3,null),(4,null); delete from t2 where a>=3; +connection master; prepare stmt1 from 'select f(?)'; set @string="try_43_"; insert into t1 values(null,"try_44_"); @@ -286,6 +296,8 @@ execute stmt1 using @string; f(?) 1 deallocate prepare stmt1; +connection slave; +connection master; create table t12 select * from t1; drop table t1; create table t1 (a int, b varchar(100), key(a)); @@ -311,12 +323,16 @@ end| select f1("try_46_"),f2("try_47_"); f1("try_46_") f2("try_47_") 1 1 +connection slave; insert into t2 values(2,null),(3,null),(4,null); delete from t2 where a>=2; +connection master; select f1("try_48_"),f2("try_49_"); f1("try_48_") f2("try_49_") 1 1 insert into t3 values(concat("try_50_",f1("try_51_"),f2("try_52_"))); +connection slave; +connection master; drop function f2; create function f2 (x varchar(100)) returns int deterministic begin @@ -328,6 +344,8 @@ end| select f1("try_53_"),f2("try_54_"); f1("try_53_") f2("try_54_") 1 3 +connection slave; +connection master; drop function f2; create trigger t1_bi before insert on t1 for each row begin @@ -336,12 +354,16 @@ end| insert into t1 values(null,"try_56_"); alter table t1 modify a int, drop primary key; insert into t1 values(null,"try_57_"); +connection slave; +connection master; CREATE TEMPORARY TABLE t15 SELECT UUID(); create table t16 like t15; INSERT INTO t16 SELECT * FROM t15; insert into t16 values("try_65_"); drop table t15; insert into t16 values("try_66_"); +connection slave; +connection master; select count(*) from t1; count(*) 7 @@ -381,6 +403,8 @@ count(*) select count(*) from t16; count(*) 3 +connection slave; +connection master; DROP TABLE IF EXISTS t11; SET SESSION BINLOG_FORMAT=STATEMENT; CREATE TABLE t11 (song VARCHAR(255)); @@ -393,16 +417,20 @@ UNLOCK TABLES; SELECT * FROM t11; song Several Species of Small Furry Animals Gathered Together in a Cave and Grooving With a Pict song Careful With That Axe, Eugene +connection slave; USE mysqltest1; SELECT * FROM t11; song Several Species of Small Furry Animals Gathered Together in a Cave and Grooving With a Pict song Careful With That Axe, Eugene +connection master; DROP TABLE IF EXISTS t12; SET SESSION BINLOG_FORMAT=MIXED; CREATE TABLE t12 (data LONG); LOCK TABLES t12 WRITE; INSERT INTO t12 VALUES(UUID()); UNLOCK TABLES; +connection slave; +connection master; CREATE FUNCTION my_user() RETURNS CHAR(64) BEGIN @@ -423,6 +451,10 @@ INSERT INTO t13 VALUES (USER()); INSERT INTO t13 VALUES (my_user()); INSERT INTO t13 VALUES (CURRENT_USER()); INSERT INTO t13 VALUES (my_current_user()); +connection slave; +connection master; drop database mysqltest1; +connection slave; +connection master; set global binlog_format =@my_binlog_format; include/rpl_end.inc |