--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