Debian Codegraph @

mysql-test/suite/rpl/r/rpl_trans_no_trans.result

raw
1 include/master-slave.inc
2 [connection master]
3 create or replace table t1(id int)engine=innodb;
4 create or replace table t3(id int)engine=myisam;
5 create or replace function t99 (a int)
6 returns int(10)
7 MODIFIES SQL DATA
8 begin
9 if (a > 100)
10 then
11 insert into t3 values (a);
12 end if;
13 return a;
14 end//
15 begin;
16 insert into t1 values(t99(1));
17 insert into t1 values(t99(101));
18 commit;
19 select * from t1;
20 id
21 1
22 101
23 select * from t3;
24 id
25 101
26 insert into t1 values(t99(1));
27 drop function t99;
28 drop table t1,t3;
29 connection slave;
30 connection master;
31 CREATE TABLE t1 (i INT) ENGINE=InnoDB;
32 CREATE TABLE t2 (j INT) ENGINE=MyISAM;
33 CREATE TRIGGER tr AFTER INSERT ON t1 FOR EACH ROW
34 BEGIN
35 SET @a = unknown_column_just_to_raise_an_error;
36 INSERT INTO t2 VALUES (NULL) ;
37 END||
38 INSERT INTO t1 VALUES (1);
39 ERROR 42S22: Unknown column 'unknown_column_just_to_raise_an_error' in 'SET'
40 connection slave;
41 connection master;
42 drop trigger tr;
43 drop table t1,t2;
44 include/rpl_end.inc