Debian Codegraph @

mysql-test/suite/ndb/r/ndb_restore_conv_lossy_charbinary.result

raw
1 Warnings:
2 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
3 ************************************************************
4 * Creating table with char+binary types
5 ************************************************************
6 CREATE TABLE t2(
7 c1 char(2), c2 char(128), c3 char(255),
8 b1 binary(2), b2 binary(128), b3 binary(255),
9 vc1 varchar(2), vc2 varchar(255), vc3 varchar(1024),
10 vb1 varbinary(2), vb2 varbinary(255), vb3 varbinary(1024)
11 ) CHARACTER SET latin1 ENGINE=NDB;
12 INSERT INTO t2 VALUES(
13 repeat('a', 2), repeat('b', 128), repeat('c', 255),
14 repeat('d', 2), repeat('e', 128), repeat('f', 255),
15 repeat('g', 2), repeat('h', 255), repeat('i', 1024),
16 repeat('j', 2), repeat('k', 255), repeat('l', 1024)
17 );
18 ************************************************************
19 * Backing up table with char+binary types
20 ************************************************************
21 ************************************************************
22 * Restoring table with unchanged char+binary types:
23 * char(2) --> char(2)
24 * char(128) --> char(128)
25 * char(255) --> char(255)
26 * binary(2) --> binary(2)
27 * binary(128) --> binary(128)
28 * binary(255) --> binary(255)
29 * varchar(2) --> varchar(2)
30 * varchar(255) --> varchar(255)
31 * varchar(1024) --> varchar(1024)
32 * varbinary(2) --> varbinary(2)
33 * varbinary(255) --> varbinary(255)
34 * varbinary(1024) --> varbinary(1024)
35 ************************************************************
36 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
37 DELETE FROM t2;
38 SELECT
39 length(c1), length(c2), length(c3),
40 length(b1), length(b2), length(b2),
41 length(vc1), length(vc2), length(vc3),
42 length(vb1), length(vb2), length(vb3)
43 FROM t2;
44 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
45 2 128 255 2 128 128 2 255 1024 2 255 1024
46 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
47 COUNT(*)
48 1
49 DROP TABLE t2_myisam;
50 ************************************************************
51 * Restoring table with 1st degree demoted char+binary types:
52 * char(2) --> char(1)
53 * char(128) --> char(2)
54 * char(255) --> char(128)
55 * binary(2) --> binary(1)
56 * binary(128) --> binary(2)
57 * binary(255) --> binary(128)
58 * varchar(2) --> varchar(1)
59 * varchar(255) --> varchar(2)
60 * varchar(1024) --> varchar(512)
61 * varbinary(2) --> varbinary(1)
62 * varbinary(255) --> varbinary(2)
63 * varbinary(1024) --> varbinary(512)
64 ************************************************************
65 ALTER TABLE t2
66 modify c1 char(1), modify c2 char(2), modify c3 char(128),
67 modify b1 binary(1), modify b2 binary(2), modify b3 binary(128),
68 modify vc1 varchar(1), modify vc2 varchar(2), modify vc3 varchar(512),
69 modify vb1 varbinary(1), modify vb2 varbinary(2), modify vb3 varbinary(512);
70 SELECT
71 length(c1), length(c2), length(c3),
72 length(b1), length(b2), length(b2),
73 length(vc1), length(vc2), length(vc3),
74 length(vb1), length(vb2), length(vb3)
75 FROM t2;
76 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
77 1 2 128 1 2 2 1 2 512 1 2 512
78 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
79 DELETE FROM t2;
80 SELECT
81 length(c1), length(c2), length(c3),
82 length(b1), length(b2), length(b2),
83 length(vc1), length(vc2), length(vc3),
84 length(vb1), length(vb2), length(vb3)
85 FROM t2;
86 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
87 1 2 128 1 2 2 1 2 512 1 2 512
88 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
89 COUNT(*)
90 1
91 DROP TABLE t2_myisam;
92 ************************************************************
93 * Restoring table with 2nd degree demoted char+binary types:
94 * char(2) --> char(1)
95 * char(128) --> char(1)
96 * char(255) --> char(2)
97 * binary(2) --> binary(1)
98 * binary(128) --> binary(1)
99 * binary(255) --> binary(2)
100 * varchar(2) --> varchar(1)
101 * varchar(255) --> varchar(1)
102 * varchar(1024) --> varchar(255)
103 * varbinary(2) --> varbinary(1)
104 * varbinary(255) --> varbinary(1)
105 * varbinary(1024) --> varbinary(255)
106 ************************************************************
107 ALTER TABLE t2
108 modify c1 char(1), modify c2 char(1), modify c3 char(2),
109 modify b1 binary(1), modify b2 binary(1), modify b3 binary(2),
110 modify vc1 varchar(1), modify vc2 varchar(1), modify vc3 varchar(255),
111 modify vb1 varbinary(1), modify vb2 varbinary(1), modify vb3 varbinary(255);
112 SELECT
113 length(c1), length(c2), length(c3),
114 length(b1), length(b2), length(b2),
115 length(vc1), length(vc2), length(vc3),
116 length(vb1), length(vb2), length(vb3)
117 FROM t2;
118 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
119 1 1 2 1 1 1 1 1 255 1 1 255
120 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
121 DELETE FROM t2;
122 SELECT
123 length(c1), length(c2), length(c3),
124 length(b1), length(b2), length(b2),
125 length(vc1), length(vc2), length(vc3),
126 length(vb1), length(vb2), length(vb3)
127 FROM t2;
128 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
129 1 1 2 1 1 1 1 1 255 1 1 255
130 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
131 COUNT(*)
132 1
133 DROP TABLE t2_myisam;
134 ************************************************************
135 * Restoring table with 3rd degree demoted char+binary types:
136 * char(2) --> char(1)
137 * char(128) --> char(1)
138 * char(255) --> char(1)
139 * binary(2) --> binary(1)
140 * binary(128) --> binary(1)
141 * binary(255) --> binary(1)
142 * varchar(2) --> varchar(1)
143 * varchar(255) --> varchar(1)
144 * varchar(1024) --> varchar(1)
145 * varbinary(2) --> varbinary(1)
146 * varbinary(255) --> varbinary(1)
147 * varbinary(1024) --> varbinary(1)
148 ************************************************************
149 ALTER TABLE t2
150 modify c1 char(1), modify c2 char(1), modify c3 char(1),
151 modify b1 binary(1), modify b2 binary(1), modify b3 binary(1),
152 modify vc1 varchar(1), modify vc2 varchar(1), modify vc3 varchar(1),
153 modify vb1 varbinary(1), modify vb2 varbinary(1), modify vb3 varbinary(1);
154 SELECT
155 length(c1), length(c2), length(c3),
156 length(b1), length(b2), length(b2),
157 length(vc1), length(vc2), length(vc3),
158 length(vb1), length(vb2), length(vb3)
159 FROM t2;
160 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
161 1 1 1 1 1 1 1 1 1 1 1 1
162 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
163 DELETE FROM t2;
164 SELECT
165 length(c1), length(c2), length(c3),
166 length(b1), length(b2), length(b2),
167 length(vc1), length(vc2), length(vc3),
168 length(vb1), length(vb2), length(vb3)
169 FROM t2;
170 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
171 1 1 1 1 1 1 1 1 1 1 1 1
172 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
173 COUNT(*)
174 1
175 DROP TABLE t2_myisam;
176 ************************************************************
177 * Restoring table with changed var-ness of char+binary types:
178 * char(2) --> varchar(2)
179 * char(128) --> varchar(128)
180 * char(255) --> varchar(255)
181 * binary(2) --> varbinary(2)
182 * binary(128) --> varbinary(128)
183 * binary(255) --> varbinary(255)
184 * varchar(2) --> char(2)
185 * varchar(255) --> char(255)
186 * varchar(1024) --> varchar(1024)
187 * varbinary(2) --> binary(2)
188 * varbinary(255) --> binary(255)
189 * varbinary(1024) --> varbinary(1024)
190 ************************************************************
191 DELETE FROM t2;
192 ALTER TABLE t2
193 modify c1 varchar(2), modify c2 varchar(128), modify c3 varchar(255),
194 modify b1 varbinary(2), modify b2 varbinary(128), modify b3 varbinary(255),
195 modify vc1 char(2), modify vc2 char(255), modify vc3 varchar(1024),
196 modify vb1 binary(2), modify vb2 binary(255), modify vb3 varbinary(1024);
197 INSERT INTO t2 VALUES(
198 repeat('a', 2), repeat('b', 128), repeat('c', 255),
199 repeat('d', 2), repeat('e', 128), repeat('f', 255),
200 repeat('g', 2), repeat('h', 255), repeat('i', 1024),
201 repeat('j', 2), repeat('k', 255), repeat('l', 1024)
202 );
203 SELECT
204 length(c1), length(c2), length(c3),
205 length(b1), length(b2), length(b2),
206 length(vc1), length(vc2), length(vc3),
207 length(vb1), length(vb2), length(vb3)
208 FROM t2;
209 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
210 2 128 255 2 128 128 2 255 1024 2 255 1024
211 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
212 DELETE FROM t2;
213 SELECT
214 length(c1), length(c2), length(c3),
215 length(b1), length(b2), length(b2),
216 length(vc1), length(vc2), length(vc3),
217 length(vb1), length(vb2), length(vb3)
218 FROM t2;
219 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
220 2 128 255 2 128 128 2 255 1024 2 255 1024
221 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
222 COUNT(*)
223 1
224 DROP TABLE t2_myisam;
225 ************************************************************
226 * Restoring table with changed varness + 1st degree demoted types:
227 * char(2) --> varchar(1)
228 * char(128) --> varchar(2)
229 * char(255) --> varchar(128)
230 * binary(2) --> varbinary(1)
231 * binary(128) --> varbinary(2)
232 * binary(255) --> varbinary(128)
233 * varchar(2) --> char(1)
234 * varchar(255) --> char(2)
235 * varchar(1024) --> char(255)
236 * varbinary(2) --> binary(1)
237 * varbinary(255) --> binary(2)
238 * varbinary(1024) --> binary(255)
239 ************************************************************
240 DELETE FROM t2;
241 ALTER TABLE t2
242 modify c1 varchar(1), modify c2 varchar(2), modify c3 varchar(128),
243 modify b1 varbinary(1), modify b2 varbinary(2), modify b3 varbinary(128),
244 modify vc1 char(1), modify vc2 char(2), modify vc3 char(255),
245 modify vb1 binary(1), modify vb2 binary(2), modify vb3 binary(255);
246 INSERT INTO t2 VALUES(
247 repeat('a', 2), repeat('b', 128), repeat('c', 255),
248 repeat('d', 2), repeat('e', 128), repeat('f', 255),
249 repeat('g', 2), repeat('h', 255), repeat('i', 1024),
250 repeat('j', 2), repeat('k', 255), repeat('l', 1024)
251 );
252 SELECT
253 length(c1), length(c2), length(c3),
254 length(b1), length(b2), length(b2),
255 length(vc1), length(vc2), length(vc3),
256 length(vb1), length(vb2), length(vb3)
257 FROM t2;
258 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
259 1 2 128 1 2 2 1 2 255 1 2 255
260 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
261 DELETE FROM t2;
262 SELECT
263 length(c1), length(c2), length(c3),
264 length(b1), length(b2), length(b2),
265 length(vc1), length(vc2), length(vc3),
266 length(vb1), length(vb2), length(vb3)
267 FROM t2;
268 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
269 1 2 128 1 2 2 1 2 255 1 2 255
270 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
271 COUNT(*)
272 1
273 DROP TABLE t2_myisam;
274 ************************************************************
275 * Restoring table with changed varness + 2nd degree demoted types:
276 * char(2) --> varchar(1)
277 * char(128) --> varchar(1)
278 * char(255) --> varchar(2)
279 * binary(2) --> varbinary(1)
280 * binary(128) --> varbinary(1)
281 * binary(255) --> varbinary(2)
282 * varchar(2) --> char(1)
283 * varchar(255) --> char(1)
284 * varchar(1024) --> char(255)
285 * varbinary(2) --> binary(1)
286 * varbinary(255) --> binary(1)
287 * varbinary(1024) --> binary(255)
288 ************************************************************
289 DELETE FROM t2;
290 ALTER TABLE t2
291 modify c1 varchar(1), modify c2 varchar(1), modify c3 varchar(2),
292 modify b1 varbinary(1), modify b2 varbinary(1), modify b3 varbinary(2),
293 modify vc1 char(1), modify vc2 char(1), modify vc3 char(255),
294 modify vb1 binary(1), modify vb2 binary(1), modify vb3 binary(255);
295 INSERT INTO t2 VALUES(
296 repeat('a', 2), repeat('b', 128), repeat('c', 255),
297 repeat('d', 2), repeat('e', 128), repeat('f', 255),
298 repeat('g', 2), repeat('h', 255), repeat('i', 1024),
299 repeat('j', 2), repeat('k', 255), repeat('l', 1024)
300 );
301 SELECT
302 length(c1), length(c2), length(c3),
303 length(b1), length(b2), length(b2),
304 length(vc1), length(vc2), length(vc3),
305 length(vb1), length(vb2), length(vb3)
306 FROM t2;
307 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
308 1 1 2 1 1 1 1 1 255 1 1 255
309 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
310 DELETE FROM t2;
311 SELECT
312 length(c1), length(c2), length(c3),
313 length(b1), length(b2), length(b2),
314 length(vc1), length(vc2), length(vc3),
315 length(vb1), length(vb2), length(vb3)
316 FROM t2;
317 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
318 1 1 2 1 1 1 1 1 255 1 1 255
319 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
320 COUNT(*)
321 1
322 DROP TABLE t2_myisam;
323 ************************************************************
324 * Restoring table with changed varness + 3rd degree demoted types:
325 * char(2) --> varchar(1)
326 * char(128) --> varchar(1)
327 * char(255) --> varchar(1)
328 * binary(2) --> varbinary(1)
329 * binary(128) --> varbinary(1)
330 * binary(255) --> varbinary(1)
331 * varchar(2) --> char(1)
332 * varchar(255) --> char(1)
333 * varchar(1024) --> char(1)
334 * varbinary(2) --> binary(1)
335 * varbinary(255) --> binary(1)
336 * varbinary(1024) --> binary(1)
337 ************************************************************
338 DELETE FROM t2;
339 ALTER TABLE t2
340 modify c1 varchar(1), modify c2 varchar(1), modify c3 varchar(1),
341 modify b1 varbinary(1), modify b2 varbinary(1), modify b3 varbinary(1),
342 modify vc1 char(1), modify vc2 char(1), modify vc3 char(1),
343 modify vb1 binary(1), modify vb2 binary(1), modify vb3 binary(1);
344 INSERT INTO t2 VALUES(
345 repeat('a', 2), repeat('b', 128), repeat('c', 255),
346 repeat('d', 2), repeat('e', 128), repeat('f', 255),
347 repeat('g', 2), repeat('h', 255), repeat('i', 1024),
348 repeat('j', 2), repeat('k', 255), repeat('l', 1024)
349 );
350 SELECT
351 length(c1), length(c2), length(c3),
352 length(b1), length(b2), length(b2),
353 length(vc1), length(vc2), length(vc3),
354 length(vb1), length(vb2), length(vb3)
355 FROM t2;
356 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
357 1 1 1 1 1 1 1 1 1 1 1 1
358 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2;
359 DELETE FROM t2;
360 SELECT
361 length(c1), length(c2), length(c3),
362 length(b1), length(b2), length(b2),
363 length(vc1), length(vc2), length(vc3),
364 length(vb1), length(vb2), length(vb3)
365 FROM t2;
366 length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3)
367 1 1 1 1 1 1 1 1 1 1 1 1
368 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam;
369 COUNT(*)
370 1
371 DROP TABLE t2_myisam;
372 ************************************************************
373 * Deleting table with char+binary types
374 ************************************************************
375 DROP TABLE t2;