Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 set @old_global_binlog_format= @@global.binlog_format;
7 Warnings:
8 Level Warning
9 Code 1287
10 Message '@@binlog_format' is deprecated and will be removed in a future release.
11 set @old_session_binlog_format= @@session.binlog_format;
12 Warnings:
13 Level Warning
14 Code 1287
15 Message '@@binlog_format' is deprecated and will be removed in a future release.
16 SET GLOBAL binlog_format = 'ROW';
17 Warnings:
18 Level Warning
19 Code 1287
20 Message '@@binlog_format' is deprecated and will be removed in a future release.
21 SET SESSION binlog_format = 'ROW';
22 Warnings:
23 Level Warning
24 Code 1287
25 Message '@@binlog_format' is deprecated and will be removed in a future release.
26 select @@global.binlog_format, @@session.binlog_format;
27 @@global.binlog_format ROW
28 @@session.binlog_format ROW
29 Warnings:
30 Level Warning
31 Code 1287
32 Message '@@binlog_format' is deprecated and will be removed in a future release.
33 Level Warning
34 Code 1287
35 Message '@@binlog_format' is deprecated and will be removed in a future release.
36 [on slave]
37 set @old_global_binlog_format= @@global.binlog_format;
38 Warnings:
39 Level Warning
40 Code 1287
41 Message '@@binlog_format' is deprecated and will be removed in a future release.
42 set @old_session_binlog_format= @@session.binlog_format;
43 Warnings:
44 Level Warning
45 Code 1287
46 Message '@@binlog_format' is deprecated and will be removed in a future release.
47 include/stop_slave.inc
48 SET GLOBAL binlog_format = 'ROW';
49 Warnings:
50 Level Warning
51 Code 1287
52 Message '@@binlog_format' is deprecated and will be removed in a future release.
53 SET SESSION binlog_format = 'ROW';
54 Warnings:
55 Level Warning
56 Code 1287
57 Message '@@binlog_format' is deprecated and will be removed in a future release.
58 select @@global.binlog_format, @@session.binlog_format;
59 @@global.binlog_format ROW
60 @@session.binlog_format ROW
61 Warnings:
62 Level Warning
63 Code 1287
64 Message '@@binlog_format' is deprecated and will be removed in a future release.
65 Level Warning
66 Code 1287
67 Message '@@binlog_format' is deprecated and will be removed in a future release.
68 include/start_slave.inc
69 [on master]
70 CREATE TABLE t1(id MEDIUMINT NOT NULL AUTO_INCREMENT,
71 dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
72 fkid MEDIUMINT, filler VARCHAR(255),
73 PRIMARY KEY(id)) charset latin1 ENGINE='innodb';
74 CREATE TABLE t2(id MEDIUMINT NOT NULL AUTO_INCREMENT,
75 dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
76 fkid MEDIUMINT, filler VARCHAR(255),
77 PRIMARY KEY(id)) charset latin1 ENGINE='innodb'
78 PARTITION BY KEY(id) partitions 5;
79 CREATE TABLE t3(id MEDIUMINT NOT NULL AUTO_INCREMENT,
80 dt TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
81 fkid MEDIUMINT, filler VARCHAR(255),
82 PRIMARY KEY(id)) ENGINE='innodb' charset latin1
83 PARTITION BY RANGE(id)
84 SUBPARTITION BY hash(id) subpartitions 2
85 (PARTITION pa1 values less than (10),
86 PARTITION pa2 values less than (20),
87 PARTITION pa3 values less than (30),
88 PARTITION pa4 values less than (40),
89 PARTITION pa5 values less than (50),
90 PARTITION pa6 values less than (60),
91 PARTITION pa7 values less than (70),
92 PARTITION pa8 values less than (80),
93 PARTITION pa9 values less than (90),
94 PARTITION pa10 values less than (100),
95 PARTITION pa11 values less than MAXVALUE);
96 CREATE PROCEDURE p1()
97 BEGIN
98 DECLARE ins_count INT DEFAULT 1000;
99 DECLARE del_count INT;
100 DECLARE cur_user VARCHAR(255);
101 DECLARE local_uuid VARCHAR(255);
102 DECLARE local_time TIMESTAMP;
103 SET local_time= NOW();
104 SET cur_user= CURRENT_USER();
105 SET local_uuid= UUID();
106 WHILE ins_count > 0 DO
107 INSERT INTO t1 VALUES (NULL, NOW(), USER() , UUID(),
108 ins_count,'Going to test MBR for MySQL');
109 SET ins_count = ins_count - 1;
110 END WHILE;
111 SELECT MAX(id) FROM t1 INTO del_count;
112 WHILE del_count > 0 DO
113 DELETE FROM t1 WHERE id = del_count;
114 SET del_count = del_count - 2;
115 END WHILE;
116 END|
117 CREATE PROCEDURE p2()
118 BEGIN
119 DECLARE ins_count INT DEFAULT 1000;
120 DECLARE del_count INT;
121 DECLARE cur_user VARCHAR(255);
122 DECLARE local_uuid VARCHAR(255);
123 DECLARE local_time TIMESTAMP;
124 SET local_time= NOW();
125 SET cur_user= CURRENT_USER();
126 SET local_uuid= UUID();
127 WHILE ins_count > 0 DO
128 INSERT INTO t2 VALUES (NULL, NOW(), USER() , UUID(),
129 ins_count,'Going to test MBR for MySQL');
130 SET ins_count = ins_count - 1;
131 END WHILE;
132 SELECT MAX(id) FROM t2 INTO del_count;
133 WHILE del_count > 0 DO
134 DELETE FROM t2 WHERE id = del_count;
135 SET del_count = del_count - 2;
136 END WHILE;
137 END|
138 CREATE PROCEDURE p3()
139 BEGIN
140 DECLARE ins_count INT DEFAULT 1000;
141 DECLARE del_count INT;
142 DECLARE cur_user VARCHAR(255);
143 DECLARE local_uuid VARCHAR(255);
144 DECLARE local_time TIMESTAMP;
145 SET local_time= NOW();
146 SET cur_user = CURRENT_USER();
147 SET local_uuid=UUID();
148 WHILE ins_count > 0 DO
149 INSERT INTO t3 VALUES (NULL, NOW(), USER(), UUID(),
150 ins_count,'Going to test MBR for MySQL');
151 SET ins_count = ins_count - 1;
152 END WHILE;
153 SELECT MAX(id) FROM t3 INTO del_count;
154 WHILE del_count > 0 DO
155 DELETE FROM t3 WHERE id = del_count;
156 SET del_count = del_count - 2;
157 END WHILE;
158 END|
159 CALL p1();
160 SELECT count(*) as "Master regular" FROM t1;
161 Master regular 500
162 CALL p2();
163 SELECT count(*) as "Master bykey" FROM t2;
164 Master bykey 500
165 CALL p3();
166 SELECT count(*) as "Master byrange" FROM t3;
167 Master byrange 500
168 show create table t3;
169 Table t3
170 Create Table CREATE TABLE `t3` (
171 `id` mediumint NOT NULL AUTO_INCREMENT,
172 `dt` timestamp NULL DEFAULT NULL,
173 `user` char(255) DEFAULT NULL,
174 `uuidf` longblob,
175 `fkid` mediumint DEFAULT NULL,
176 `filler` varchar(255) DEFAULT NULL,
177 PRIMARY KEY (`id`)
178 ) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=latin1
179 /*!50100 PARTITION BY RANGE (`id`)
180 SUBPARTITION BY HASH (`id`)
181 SUBPARTITIONS 2
182 (PARTITION pa1 VALUES LESS THAN (10) ENGINE = InnoDB,
183 PARTITION pa2 VALUES LESS THAN (20) ENGINE = InnoDB,
184 PARTITION pa3 VALUES LESS THAN (30) ENGINE = InnoDB,
185 PARTITION pa4 VALUES LESS THAN (40) ENGINE = InnoDB,
186 PARTITION pa5 VALUES LESS THAN (50) ENGINE = InnoDB,
187 PARTITION pa6 VALUES LESS THAN (60) ENGINE = InnoDB,
188 PARTITION pa7 VALUES LESS THAN (70) ENGINE = InnoDB,
189 PARTITION pa8 VALUES LESS THAN (80) ENGINE = InnoDB,
190 PARTITION pa9 VALUES LESS THAN (90) ENGINE = InnoDB,
191 PARTITION pa10 VALUES LESS THAN (100) ENGINE = InnoDB,
192 PARTITION pa11 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
193 include/check_slave_is_running.inc
194 SELECT count(*) "Slave norm" FROM t1;
195 Slave norm 500
196 SELECT count(*) "Slave bykey" FROM t2;
197 Slave bykey 500
198 SELECT count(*) "Slave byrange" FROM t3;
199 Slave byrange 500
200 set @@global.binlog_format= @old_global_binlog_format;
201 Warnings:
202 Level Warning
203 Code 1287
204 Message '@@binlog_format' is deprecated and will be removed in a future release.
205 set @@session.binlog_format= @old_session_binlog_format;
206 Warnings:
207 Level Warning
208 Code 1287
209 Message '@@binlog_format' is deprecated and will be removed in a future release.
210 DROP TABLE t1, t2, t3;
211 DROP PROCEDURE p1;
212 DROP PROCEDURE p2;
213 DROP PROCEDURE p3;
214 [on slave]
215 include/stop_slave_sql.inc
216 set @@global.binlog_format= @old_global_binlog_format;
217 Warnings:
218 Level Warning
219 Code 1287
220 Message '@@binlog_format' is deprecated and will be removed in a future release.
221 set @@session.binlog_format= @old_session_binlog_format;
222 Warnings:
223 Level Warning
224 Code 1287
225 Message '@@binlog_format' is deprecated and will be removed in a future release.
226 include/rpl_end.inc