Debian Codegraph @

mysql-test/suite/rpl/t/rpl_innodb_bug30888.test

raw
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';
10 let $engine_type= 'innodb';
11
12 ######## Creat Table Section #########
13 use test;
14
15 eval 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
22 --enable_prepare_warnings
23 delimiter |;
24 CREATE PROCEDURE test.proc_norm()
25 BEGIN
26 DECLARE ins_count INT DEFAULT 1000;
27 DECLARE del_count INT;
28 DECLARE cur_user VARCHAR(255);
29 DECLARE local_uuid VARCHAR(255);
30 DECLARE local_time TIMESTAMP;
31
32 SET local_time= NOW();
33 SET cur_user= CURRENT_USER();
34 SET local_uuid= UUID();
35
36 WHILE ins_count > 0 DO
37 INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(),
38 ins_count,'Going to test MBR for MySQL');
39 SET ins_count = ins_count - 1;
40 END WHILE;
41
42 SELECT MAX(id) FROM test.regular_tbl INTO del_count;
43 WHILE del_count > 0 DO
44 DELETE FROM test.regular_tbl WHERE id = del_count;
45 SET del_count = del_count - 2;
46 END WHILE;
47 END|
48
49 delimiter ;|
50 --disable_prepare_warnings
51 ############ Finish Setup Section ###################
52
53
54 ############ Test Section ###################
55
56 CALL test.proc_norm();
57
58 --sync_slave_with_master
59
60 ###### CLEAN UP SECTION ##############
61
62 connection master;
63 DROP PROCEDURE test.proc_norm;
64 DROP TABLE test.regular_tbl;
65
66 --source include/rpl_end.inc
67