2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
CALL mtr.add_suppression('Statement may not be safe to log in statement format.');
8
DROP FUNCTION IF EXISTS test.f1;
9
DROP TABLE IF EXISTS test.t1;
10
CREATE TABLE test.t1 (a INT NOT NULL AUTO_INCREMENT, c CHAR(16),PRIMARY KEY(a))ENGINE=INNODB;
11
create function test.f1() RETURNS CHAR(16)
14
DECLARE var_name FLOAT;
15
SET var_name = RAND();
17
THEN SET tmp = 'Texas';
18
ELSE SET tmp = 'MySQL';
22
INSERT INTO test.t1 VALUES (null,test.f1()),(null,test.f1()),(null,test.f1());
23
INSERT INTO test.t1 VALUES (null,test.f1()),(null,test.f1()),(null,test.f1());
26
INSERT INTO test.t1 VALUES (null,test.f1());
29
DROP FUNCTION test.f1;