Debian Codegraph @

mysql-test/suite/parts/r/rpl-partition-dml-1-1-innodb.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 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
9 set @old_session_binlog_format= @@session.binlog_format;
10 Warnings:
11 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
12 SET GLOBAL binlog_format = 'ROW';
13 Warnings:
14 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
15 SET SESSION binlog_format = 'ROW';
16 Warnings:
17 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
18 select @@global.binlog_format, @@session.binlog_format;
19 @@global.binlog_format @@session.binlog_format
20 ROW ROW
21 Warnings:
22 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
23 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
24 [on slave]
25 set @old_global_binlog_format= @@global.binlog_format;
26 Warnings:
27 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
28 set @old_session_binlog_format= @@session.binlog_format;
29 Warnings:
30 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
31 include/stop_slave.inc
32 SET GLOBAL binlog_format = 'ROW';
33 Warnings:
34 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
35 SET SESSION binlog_format = 'ROW';
36 Warnings:
37 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
38 select @@global.binlog_format, @@session.binlog_format;
39 @@global.binlog_format @@session.binlog_format
40 ROW ROW
41 Warnings:
42 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
43 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
44 include/start_slave.inc
45 # Additional tests for WL#5217 by QA, testplan 1.1
46 CREATE TABLE t1
47 (a INT NOT NULL,
48 b varchar (64),
49 INDEX ind_t1 (b,a),
50 PRIMARY KEY (a))
51 ENGINE = InnoDB
52 PARTITION BY RANGE (a)
53 SUBPARTITION BY HASH (a) SUBPARTITIONS 3
54 (PARTITION pNeg VALUES LESS THAN (0)
55 (SUBPARTITION subp0 ,
56 SUBPARTITION subp1 ,
57 SUBPARTITION subp2 ),
58 PARTITION `p0-29` VALUES LESS THAN (30)
59 (SUBPARTITION subp3 ,
60 SUBPARTITION subp4 ,
61 SUBPARTITION subp5 ),
62 PARTITION `p30-299` VALUES LESS THAN (300)
63 (SUBPARTITION subp6 ,
64 SUBPARTITION subp7 ,
65 SUBPARTITION subp8 ),
66 PARTITION `p300-2999` VALUES LESS THAN (3000)
67 (SUBPARTITION subp9 ,
68 SUBPARTITION subp10 ,
69 SUBPARTITION subp11 ),
70 PARTITION `p3000-299999` VALUES LESS THAN (300000)
71 (SUBPARTITION subp12 ,
72 SUBPARTITION subp13 ,
73 SUBPARTITION subp14 ));
74 INSERT INTO t1 PARTITION (pNeg, subp0) VALUES (-4, '(pNeg-)subp0');
75 INSERT INTO t1 PARTITION (pNeg, subp0) VALUES (-3, '(pNeg-)subp0');
76 INSERT INTO t1 PARTITION (pNeg, subp0) VALUES (-2, '(pNeg-)subp0');
77 INSERT INTO t1 PARTITION (pNeg, subp0) VALUES (-1, '(pNeg-)subp0');
78 INSERT INTO t1 PARTITION (`p0-29`, subp3) VALUES (4, '(p0-29-)subp3');
79 INSERT INTO t1 PARTITION (`p0-29`, subp3) VALUES (3, '(p0-29-)subp3');
80 INSERT INTO t1 PARTITION (`p0-29`, subp3) VALUES (2, '(p0-29-)subp3');
81 INSERT INTO t1 PARTITION (`p0-29`, subp3) VALUES (1, '(p0-29-)subp3');
82 INSERT INTO t1 PARTITION (`p0-29`, subp5) VALUES (24, '(p0-29-)subp5');
83 INSERT INTO t1 PARTITION (`p0-29`, subp5) VALUES (23, '(p0-29-)subp5');
84 INSERT INTO t1 PARTITION (`p0-29`, subp5) VALUES (22, '(p0-29-)subp5');
85 INSERT INTO t1 PARTITION (`p0-29`, subp5) VALUES (21, '(p0-29-)subp5');
86 INSERT INTO t1 PARTITION (`p30-299`, subp9) VALUES (34, '(p30-299-)subp6');
87 INSERT INTO t1 PARTITION (`p30-299`, subp9) VALUES (33, '(p30-299-)subp6');
88 INSERT INTO t1 PARTITION (`p30-299`, subp9) VALUES (32, '(p30-299-)subp6');
89 INSERT INTO t1 PARTITION (`p30-299`, subp9) VALUES (31, '(p30-299-)subp6');
90 INSERT INTO t1 PARTITION (`p30-299`, subp8) VALUES (234, '(p30-299-)subp8');
91 INSERT INTO t1 PARTITION (`p30-299`, subp8) VALUES (233, '(p30-299-)subp8');
92 INSERT INTO t1 PARTITION (`p30-299`, subp8) VALUES (232, '(p30-299-)subp8');
93 INSERT INTO t1 PARTITION (`p30-299`, subp8) VALUES (231, '(p30-299-)subp8');
94 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (304, '(p300-2999-)subp8');
95 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (303, '(p300-2999-)subp8');
96 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (302, '(p300-2999-)subp8');
97 INSERT INTO t1 PARTITION (`p300-2999`, subp8) VALUES (301, '(p300-2999-)subp8');
98 INSERT INTO t1 PARTITION (`p3000-299999`, subp12) VALUES (3004, '(p3000-299999-)subp12');
99 INSERT INTO t1 PARTITION (`p3000-299999`, subp12) VALUES (3003, '(p3000-299999-)subp12');
100 INSERT INTO t1 PARTITION (`p3000-299999`, subp12) VALUES (3002, '(p3000-299999-)subp12');
101 INSERT INTO t1 PARTITION (`p3000-299999`, subp12) VALUES (3001, '(p3000-299999-)subp12');
102 INSERT INTO t1 PARTITION (`p3000-299999`, subp14) VALUES (299996, '(p3000-299999-)subp14');
103 INSERT INTO t1 PARTITION (`p3000-299999`, subp14) VALUES (299997, '(p3000-299999-)subp14');
104 INSERT INTO t1 PARTITION (`p3000-299999`, subp14) VALUES (299998, '(p3000-299999-)subp14');
105 INSERT INTO t1 PARTITION (`p3000-299999`, subp14) VALUES (299999, '(p3000-299999-)subp14');
106 SELECT * FROM t1 PARTITION (`p0-29`);
107 a b
108 1 (p0-29-)subp3
109 2 (p0-29-)subp3
110 21 (p0-29-)subp5
111 22 (p0-29-)subp5
112 23 (p0-29-)subp5
113 24 (p0-29-)subp5
114 3 (p0-29-)subp3
115 4 (p0-29-)subp3
116 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
117 SELECT * FROM t1 PARTITION (`p0-29`);
118 a b
119 1 p0-29-upd-1
120 2 p0-29-upd-1
121 21 (p0-29-)subp5
122 22 (p0-29-)subp5
123 23 (p0-29-)subp5
124 24 (p0-29-)subp5
125 3 p0-29-upd-1
126 4 p0-29-upd-1
127 connection slave;
128 include/check_slave_is_running.inc
129 connection slave;
130 connection slave;
131 connection slave;
132 SELECT * FROM t1 PARTITION (`p0-29`);
133 a b
134 1 p0-29-upd-1
135 2 p0-29-upd-1
136 21 (p0-29-)subp5
137 22 (p0-29-)subp5
138 23 (p0-29-)subp5
139 24 (p0-29-)subp5
140 3 p0-29-upd-1
141 4 p0-29-upd-1
142 connection master;
143 UPDATE t1 PARTITION (`p30-299`) SET b='p30-299-upd' WHERE a BETWEEN 30 AND 39;
144 SELECT * FROM t1 PARTITION (`p30-299`);
145 a b
146 231 (p30-299-)subp8
147 232 (p30-299-)subp8
148 233 (p30-299-)subp8
149 234 (p30-299-)subp8
150 31 p30-299-upd
151 32 p30-299-upd
152 33 p30-299-upd
153 34 p30-299-upd
154 connection slave;
155 include/check_slave_is_running.inc
156 connection slave;
157 connection slave;
158 connection slave;
159 SELECT * FROM t1 PARTITION (`p30-299`);
160 a b
161 231 (p30-299-)subp8
162 232 (p30-299-)subp8
163 233 (p30-299-)subp8
164 234 (p30-299-)subp8
165 31 p30-299-upd
166 32 p30-299-upd
167 33 p30-299-upd
168 34 p30-299-upd
169 connection master;
170 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
171 SELECT * FROM t1 PARTITION (`p300-2999`);
172 a b
173 301 p300-2999-upd
174 302 p300-2999-upd
175 303 p300-2999-upd
176 304 p300-2999-upd
177 connection slave;
178 include/check_slave_is_running.inc
179 connection slave;
180 connection slave;
181 connection slave;
182 SELECT * FROM t1 PARTITION (`p300-2999`);
183 a b
184 301 p300-2999-upd
185 302 p300-2999-upd
186 303 p300-2999-upd
187 304 p300-2999-upd
188 connection master;
189 UPDATE t1 PARTITION (subp3) SET b='subp3-upd';
190 UPDATE t1 PARTITION (subp4) SET b='subp4-upd';
191 UPDATE t1 PARTITION (subp5) SET b='subp5-upd';
192 SELECT * FROM t1 PARTITION (subp4,subp5,subp3) order by b,a;
193 a b
194 1 subp4-upd
195 2 subp5-upd
196 21 subp3-upd
197 22 subp4-upd
198 23 subp5-upd
199 24 subp3-upd
200 3 subp3-upd
201 4 subp4-upd
202 connection slave;
203 include/check_slave_is_running.inc
204 connection slave;
205 connection slave;
206 connection slave;
207 SELECT * FROM t1 PARTITION (subp4,subp5,subp3) order by b,a;
208 a b
209 1 subp4-upd
210 2 subp5-upd
211 21 subp3-upd
212 22 subp4-upd
213 23 subp5-upd
214 24 subp3-upd
215 3 subp3-upd
216 4 subp4-upd
217 include/stop_slave_sql.inc
218 connection slave;
219 set @@global.binlog_format= @old_global_binlog_format;
220 Warnings:
221 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
222 include/start_slave_sql.inc
223 connection slave;
224 set @@session.binlog_format= @old_session_binlog_format;
225 Warnings:
226 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
227 connection master;
228 set @@global.binlog_format= @old_global_binlog_format;
229 Warnings:
230 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
231 set @@session.binlog_format= @old_session_binlog_format;
232 Warnings:
233 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
234 DROP TABLE t1;
235 include/rpl_end.inc