Debian Codegraph @

mysql-test/suite/rpl/r/rpl_innodb_bug28430.result

raw
1 include/master-slave.inc
2 [connection master]
3 use test;
4 CREATE TABLE test.regular_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
5 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON
6 UPDATE CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
7 fkid MEDIUMINT, filler VARCHAR(255),
8 PRIMARY KEY(id)) ENGINE='innodb';
9 CREATE TABLE test.bykey_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
10 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
11 CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
12 fkid MEDIUMINT, filler VARCHAR(255),
13 PRIMARY KEY(id)) ENGINE='innodb'
14 PARTITION BY KEY(id) partitions 5;
15 CREATE TABLE test.byrange_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
16 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
17 CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
18 fkid MEDIUMINT, filler VARCHAR(255),
19 PRIMARY KEY(id)) ENGINE='innodb'
20 PARTITION BY RANGE(id)
21 SUBPARTITION BY hash(id) subpartitions 2
22 (PARTITION pa1 values less than (10),
23 PARTITION pa2 values less than (20),
24 PARTITION pa3 values less than (30),
25 PARTITION pa4 values less than (40),
26 PARTITION pa5 values less than (50),
27 PARTITION pa6 values less than (60),
28 PARTITION pa7 values less than (70),
29 PARTITION pa8 values less than (80),
30 PARTITION pa9 values less than (90),
31 PARTITION pa10 values less than (100),
32 PARTITION pa11 values less than MAXVALUE);
33 CREATE PROCEDURE test.proc_norm()
34 BEGIN
35 DECLARE ins_count INT DEFAULT 1000;
36 DECLARE del_count INT;
37 DECLARE cur_user VARCHAR(255);
38 DECLARE local_uuid VARCHAR(255);
39 DECLARE local_time TIMESTAMP;
40 SET local_time= NOW();
41 SET cur_user= CURRENT_USER();
42 SET local_uuid= UUID();
43 WHILE ins_count > 0 DO
44 INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(),
45 ins_count,'Going to test MBR for MySQL');
46 SET ins_count = ins_count - 1;
47 END WHILE;
48 SELECT MAX(id) FROM test.regular_tbl INTO del_count;
49 WHILE del_count > 0 DO
50 DELETE FROM test.regular_tbl WHERE id = del_count;
51 SET del_count = del_count - 2;
52 END WHILE;
53 END|
54 CREATE PROCEDURE test.proc_bykey()
55 BEGIN
56 DECLARE ins_count INT DEFAULT 1000;
57 DECLARE del_count INT;
58 DECLARE cur_user VARCHAR(255);
59 DECLARE local_uuid VARCHAR(255);
60 DECLARE local_time TIMESTAMP;
61 SET local_time= NOW();
62 SET cur_user= CURRENT_USER();
63 SET local_uuid= UUID();
64 WHILE ins_count > 0 DO
65 INSERT INTO test.bykey_tbl VALUES (NULL, NOW(), USER() , UUID(),
66 ins_count,'Going to test MBR for MySQL');
67 SET ins_count = ins_count - 1;
68 END WHILE;
69 SELECT MAX(id) FROM test.bykey_tbl INTO del_count;
70 WHILE del_count > 0 DO
71 DELETE FROM test.bykey_tbl WHERE id = del_count;
72 SET del_count = del_count - 2;
73 END WHILE;
74 END|
75 CREATE PROCEDURE test.proc_byrange()
76 BEGIN
77 DECLARE ins_count INT DEFAULT 1000;
78 DECLARE del_count INT;
79 DECLARE cur_user VARCHAR(255);
80 DECLARE local_uuid VARCHAR(255);
81 DECLARE local_time TIMESTAMP;
82 SET local_time= NOW();
83 SET cur_user = CURRENT_USER();
84 SET local_uuid=UUID();
85 WHILE ins_count > 0 DO
86 INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(),
87 ins_count,'Going to test MBR for MySQL');
88 SET ins_count = ins_count - 1;
89 END WHILE;
90 SELECT MAX(id) FROM test.byrange_tbl INTO del_count;
91 WHILE del_count > 0 DO
92 DELETE FROM test.byrange_tbl WHERE id = del_count;
93 SET del_count = del_count - 2;
94 END WHILE;
95 END|
96 begin;
97 CALL test.proc_norm();
98 commit;
99 SELECT count(*) as "Master regular" FROM test.regular_tbl;
100 Master regular 500
101 begin;
102 CALL test.proc_bykey();
103 commit;
104 SELECT count(*) as "Master bykey" FROM test.bykey_tbl;
105 Master bykey 500
106 begin;
107 CALL test.proc_byrange();
108 commit;
109 SELECT count(*) as "Master byrange" FROM test.byrange_tbl;
110 Master byrange 500
111 connection slave;
112 connection slave;
113 show create table test.byrange_tbl;
114 Table byrange_tbl
115 Create Table CREATE TABLE `byrange_tbl` (
116 `id` mediumint(9) NOT NULL AUTO_INCREMENT,
117 `dt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
118 `user` char(255) DEFAULT NULL,
119 `uuidf` longblob DEFAULT NULL,
120 `fkid` mediumint(9) DEFAULT NULL,
121 `filler` varchar(255) DEFAULT NULL,
122 PRIMARY KEY (`id`)
123 ) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
124 PARTITION BY RANGE (`id`)
125 SUBPARTITION BY HASH (`id`)
126 SUBPARTITIONS 2
127 (PARTITION `pa1` VALUES LESS THAN (10) ENGINE = InnoDB,
128 PARTITION `pa2` VALUES LESS THAN (20) ENGINE = InnoDB,
129 PARTITION `pa3` VALUES LESS THAN (30) ENGINE = InnoDB,
130 PARTITION `pa4` VALUES LESS THAN (40) ENGINE = InnoDB,
131 PARTITION `pa5` VALUES LESS THAN (50) ENGINE = InnoDB,
132 PARTITION `pa6` VALUES LESS THAN (60) ENGINE = InnoDB,
133 PARTITION `pa7` VALUES LESS THAN (70) ENGINE = InnoDB,
134 PARTITION `pa8` VALUES LESS THAN (80) ENGINE = InnoDB,
135 PARTITION `pa9` VALUES LESS THAN (90) ENGINE = InnoDB,
136 PARTITION `pa10` VALUES LESS THAN (100) ENGINE = InnoDB,
137 PARTITION `pa11` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
138 SELECT count(*) "Slave norm" FROM test.regular_tbl;
139 Slave norm 500
140 SELECT count(*) "Slave bykey" FROM test.bykey_tbl;
141 Slave bykey 500
142 SELECT count(*) "Slave byrange" FROM test.byrange_tbl;
143 Slave byrange 500
144 connection master;
145 DROP PROCEDURE test.proc_norm;
146 DROP PROCEDURE test.proc_bykey;
147 DROP PROCEDURE test.proc_byrange;
148 DROP TABLE test.regular_tbl;
149 DROP TABLE test.bykey_tbl;
150 DROP TABLE test.byrange_tbl;
151 include/rpl_end.inc