--source include/have_innodb.inc --source include/have_binlog_format_mixed_or_row.inc --source include/master-slave.inc # Set the default connection to 'master' --vertical_results #let $engine_type= 'myisam'; let $engine_type= 'innodb'; ######## Creat Table Section ######### use test; eval CREATE TABLE test.regular_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT, dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB, fkid MEDIUMINT, filler VARCHAR(255), PRIMARY KEY(id)) ENGINE=$engine_type; ######## Create SPs, Functions, Views and Triggers Section ############## delimiter |; CREATE PROCEDURE test.proc_norm() BEGIN DECLARE ins_count INT DEFAULT 1000; DECLARE del_count INT; DECLARE cur_user VARCHAR(255); DECLARE local_uuid VARCHAR(255); DECLARE local_time TIMESTAMP; SET local_time= NOW(); SET cur_user= CURRENT_USER(); SET local_uuid= UUID(); WHILE ins_count > 0 DO INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(), ins_count,'Going to test MBR for MySQL'); SET ins_count = ins_count - 1; END WHILE; SELECT MAX(id) FROM test.regular_tbl INTO del_count; WHILE del_count > 0 DO DELETE FROM test.regular_tbl WHERE id = del_count; SET del_count = del_count - 2; END WHILE; END| delimiter ;| ############ Finish Setup Section ################### ############ Test Section ################### CALL test.proc_norm(); --sync_slave_with_master ###### CLEAN UP SECTION ############## connection master; DROP PROCEDURE test.proc_norm; DROP TABLE test.regular_tbl; --source include/master-slave-end.inc