Debian Codegraph @

mysql-test/suite/parts/r/rpl_partition.result

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