~drizzle-trunk/drizzle/development

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