1--source include/have_innodb.inc
2--source include/have_binlog_format_mixed_or_row.inc
3--source include/master-slave.inc
4
5# Set the default connection to 'master'
6
7--vertical_results
8
9#let $engine_type= 'myisam';
10let $engine_type= 'innodb';
11
12######## Creat Table Section #########
13use test;
14
15eval CREATE TABLE test.regular_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
16                           dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
17                           fkid MEDIUMINT, filler VARCHAR(255),
18                           PRIMARY KEY(id)) ENGINE=$engine_type;
19
20######## Create SPs, Functions, Views and Triggers Section ##############
21
22delimiter |;
23CREATE PROCEDURE test.proc_norm()
24BEGIN
25   DECLARE ins_count INT DEFAULT 1000;
26   DECLARE del_count INT;
27   DECLARE cur_user VARCHAR(255);
28   DECLARE local_uuid VARCHAR(255);
29   DECLARE local_time TIMESTAMP;
30
31   SET local_time= NOW();
32   SET cur_user= CURRENT_USER();
33   SET local_uuid= UUID();
34
35   WHILE ins_count > 0 DO
36     INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(),
37                                   ins_count,'Going to test MBR for MySQL');
38     SET ins_count = ins_count - 1;
39   END WHILE;
40
41   SELECT MAX(id) FROM test.regular_tbl INTO del_count;
42   WHILE del_count > 0 DO
43     DELETE FROM test.regular_tbl WHERE id = del_count;
44     SET del_count = del_count - 2;
45   END WHILE;
46END|
47
48delimiter ;|
49
50############ Finish Setup Section ###################
51
52
53############ Test Section ###################
54
55CALL test.proc_norm();
56
57--sync_slave_with_master
58
59###### CLEAN UP SECTION ##############
60
61connection master;
62DROP PROCEDURE test.proc_norm;
63DROP TABLE test.regular_tbl;
64
65--source include/rpl_end.inc
66
67