Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 CALL mtr.add_suppression('Statement may not be safe to log in statement format.');
4 connection master;
5 DROP FUNCTION IF EXISTS test.f1;
6 DROP TABLE IF EXISTS test.t1;
7 CREATE TABLE test.t1 (a INT NOT NULL AUTO_INCREMENT, c CHAR(16),PRIMARY KEY(a))ENGINE=INNODB;
8 create function test.f1() RETURNS CHAR(16)
9 BEGIN
10 DECLARE tmp CHAR(16);
11 DECLARE var_name FLOAT;
12 SET var_name = RAND();
13 IF var_name > .6
14 THEN SET tmp = 'Texas';
15 ELSE SET tmp = 'MySQL';
16 END IF;
17 RETURN tmp;
18 END|
19 INSERT INTO test.t1 VALUES (null,test.f1()),(null,test.f1()),(null,test.f1());
20 INSERT INTO test.t1 VALUES (null,test.f1()),(null,test.f1()),(null,test.f1());
21 SET AUTOCOMMIT=0;
22 START TRANSACTION;
23 INSERT INTO test.t1 VALUES (null,test.f1());
24 ROLLBACK;
25 SET AUTOCOMMIT=1;
26 connection slave;
27 connection master;
28 DROP FUNCTION test.f1;
29 DROP TABLE test.t1;
30 include/rpl_end.inc