Debian Codegraph @

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

raw
1 # bug#17275798
2 create table t1 (
3 a int unsigned primary key,
4 b char(20) character set latin1,
5 c int unsigned
6 ) engine=ndb;
7 # restore canned backup
8 select sum(1),sum(isnull(b)),min(b),max(b) from t1;
9 sum(1) sum(isnull(b)) min(b) max(b)
10 100 15 +z3kg ZOOa2
11 drop table t1;
12 # bug#17395298
13 create table t1 (
14 a int primary key,
15 b text,
16 c int
17 ) engine=ndb;
18 insert into t1 values (1,repeat('a',1000),10);
19 insert into t1 values (2,repeat('b',2000),20);
20 insert into t1 values (3,repeat('c',3000),30);
21 # run backup
22 rename table t1 to t1old;
23 create table t1 (
24 a int primary key,
25 c int,
26 b text
27 ) engine=ndb;
28 # run restore
29 select count(*) from t1 x, t1old y
30 where x.a = y.a and x.b = y.b and x.c = y.c;
31 count(*)
32 3
33 drop table t1old;
34 drop table t1;
35 # bug#17235051 : char<->binary
36 # plain restore
37 create table t1 (
38 c1 char(10),
39 c2 varchar(100),
40 c3 varchar(1000),
41 b1 binary(10),
42 b2 varbinary(100),
43 b3 varbinary(1000),
44 d varchar(8000),
45 a int unsigned primary key
46 ) engine=ndb character set latin1;
47 insert into t1 values
48 ('aaa1','bbb1','ccc1','ddd1','eee1','fff1',repeat('x',2000),1),
49 ('aaa2','bbb2','ccc2','ddd2','eee2','fff2',repeat('y',4000),2),
50 ('aaa3','bbb3','ccc3','ddd3','eee3','fff3',repeat('z',6000),3);
51 select a,
52 trim(trailing char(0) from c1) as c1,c2,c3,
53 trim(trailing char(0) from b1) as b1,b2,b3
54 from t1 order by a;
55 a c1 c2 c3 b1 b2 b3
56 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1
57 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2
58 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3
59 # run backup
60 drop table t1;
61 create table t1 (
62 b1 char(10),
63 b2 varchar(100),
64 b3 varchar(1000),
65 c1 binary(10),
66 c2 varbinary(100),
67 c3 varbinary(1000),
68 d varchar(8000),
69 a int unsigned primary key
70 ) engine=ndb character set latin1;
71 # run restore
72 select a,
73 trim(trailing char(0) from c1) as c1,c2,c3,
74 trim(trailing char(0) from b1) as b1,b2,b3
75 from t1 order by a;
76 a c1 c2 c3 b1 b2 b3
77 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1
78 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2
79 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3
80 drop table t1;
81 # staging restore
82 create table t1 (
83 c1 char(10),
84 c2 varchar(100),
85 c3 varchar(1000),
86 b1 binary(10),
87 b2 varbinary(100),
88 b3 varbinary(1000),
89 d varchar(8000),
90 a int unsigned primary key
91 ) engine=ndb character set latin1;
92 insert into t1 values
93 ('aaa1','bbb1','ccc1','ddd1','eee1','fff1',repeat('x',2000),1),
94 ('aaa2','bbb2','ccc2','ddd2','eee2','fff2',repeat('y',4000),2),
95 ('aaa3','bbb3','ccc3','ddd3','eee3','fff3',repeat('z',6000),3);
96 select a,
97 trim(trailing char(0) from c1) as c1,c2,c3,
98 trim(trailing char(0) from b1) as b1,b2,b3
99 from t1 order by a;
100 a c1 c2 c3 b1 b2 b3
101 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1
102 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2
103 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3
104 # run backup
105 drop table t1;
106 create table t1 (
107 b1 char(10),
108 b2 varchar(100),
109 b3 varchar(1000),
110 c1 binary(10),
111 c2 varbinary(100),
112 c3 varbinary(1000),
113 d text,
114 a int unsigned primary key
115 ) engine=ndb character set latin1;
116 # run restore
117 select a,
118 trim(trailing char(0) from c1) as c1,c2,c3,
119 trim(trailing char(0) from b1) as b1,b2,b3
120 from t1 order by a;
121 a c1 c2 c3 b1 b2 b3
122 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1
123 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2
124 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3
125 drop table t1;
126 # create tablespace
127 create logfile group lg1
128 add undofile 'undofile1.dat'
129 initial_size 8M
130 undo_buffer_size 1M
131 engine=ndb;
132 create tablespace ts1
133 add datafile 'datafile1.dat'
134 use logfile group lg1
135 initial_size 96M
136 engine=ndb;
137 # bug#17235051 : char<->text
138 create table t1 (
139 b text,
140 c varchar(8000) character set latin1,
141 d text,
142 a int unsigned primary key
143 ) engine=ndb;
144 insert into t1 values (repeat('a',3333),repeat('b',5555),repeat('c',7777),1);
145 insert into t1 values (repeat('d',7777),repeat('e',5555),repeat('f',3333),2);
146 insert into t1 values (null,repeat('h',5555),repeat('i',3333),3);
147 insert into t1 values (repeat('j',7777),null,repeat('l',3333),4);
148 insert into t1 values (repeat('m',7777),repeat('n',5555),null,5);
149 select count(*),sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z')))) from t1;
150 count(*) sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z'))))
151 5 12314487834
152 # run backup
153 drop table t1;
154 create table t1 (
155 b varchar(8000) character set latin1,
156 c text,
157 d text,
158 a int unsigned primary key
159 ) engine=ndb;
160 # run restore
161 select count(*),sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z')))) from t1;
162 count(*) sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z'))))
163 5 12314487834
164 drop table t1;
165 # bug#17235051 : remap columns and missing columns
166 create table t1 (
167 x int,
168 a int primary key auto_increment,
169 b int,
170 c bigint,
171 y int,
172 d varchar(8000) character set latin1
173 ) engine=ndb;
174 insert into t1 (x,b,c,d) values (1,10,100,repeat('d',30));
175 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
176 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
177 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
178 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
179 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
180 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
181 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
182 insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1;
183 select count(*),max(a),max(b),max(c),max(length(d)) from t1;
184 count(*) max(a) max(b) max(c) max(length(d))
185 256 256 65610 6553600 7680
186 # run backup
187 rename table t1 to t1old;
188 create table t1 (
189 d text,
190 z char(10),
191 b int,
192 w char(10),
193 c bigint,
194 a int primary key auto_increment
195 ) engine=ndb;
196 # run restore
197 select count(*),max(a),max(b),max(c),max(length(d)) from t1;
198 count(*) max(a) max(b) max(c) max(length(d))
199 256 256 65610 6553600 7680
200 select count(*) from t1 x, t1old y
201 where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d;
202 count(*)
203 256
204 drop table t1old;
205 drop table t1;
206 # bug#17235051 : lossy conversions
207 create table t1 (
208 a char(1) primary key,
209 b text,
210 c varchar(10) character set latin1
211 ) engine=ndb;
212 insert into t1 values ('a',concat('x',repeat('a',1000)),'0123456789');
213 insert into t1 values ('b',concat('y',repeat('b',2000)),'012345');
214 insert into t1 values ('c',concat('z',repeat('c',3000)),'01234');
215 select a,length(b),trim(trailing a from b),c
216 from t1 order by a;
217 a length(b) trim(trailing a from b) c
218 a 1001 x 0123456789
219 b 2001 y 012345
220 c 3001 z 01234
221 # run backup
222 drop table t1;
223 create table t1 (
224 a char(1) primary key,
225 b varchar(2001) character set latin1,
226 c varchar(5) character set latin1
227 ) engine=ndb;
228 # run restore
229 select a,length(b),trim(trailing a from b),c
230 from t1 order by a;
231 a length(b) trim(trailing a from b) c
232 a 1001 x 01234
233 b 2001 y 01234
234 c 2001 z 01234
235 drop table t1;
236 # bug#17235051 : char<->text + disk data
237 create table t1old (
238 a int unsigned primary key auto_increment,
239 b text,
240 c varchar(8000) character set latin1,
241 d text,
242 e varchar(20),
243 f int
244 ) engine=ndb;
245 insert into t1old (b,c,d,e,f)
246 values (repeat('b',20),repeat('c',30),repeat('d',40),'e',1);
247 insert into t1old (b,c,d,e,f)
248 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
249 from t1old;
250 insert into t1old (b,c,d,e,f)
251 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
252 from t1old;
253 insert into t1old (b,c,d,e,f)
254 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
255 from t1old;
256 insert into t1old (b,c,d,e,f)
257 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
258 from t1old;
259 insert into t1old (b,c,d,e,f)
260 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
261 from t1old;
262 insert into t1old (b,c,d,e,f)
263 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
264 from t1old;
265 insert into t1old (b,c,d,e,f)
266 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
267 from t1old;
268 insert into t1old (b,c,d,e,f)
269 select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f
270 from t1old;
271 select count(*),max(length(b)),max(length(c)),max(length(d)),max(length(e)),max(f)
272 from t1old;
273 count(*) max(length(b)) max(length(c)) max(length(d)) max(length(e)) max(f)
274 256 7680 7690 7670 9 256
275 # restore mem->mem
276 create table t1 (
277 a int unsigned primary key auto_increment,
278 b text,
279 c varchar(8000) character set latin1,
280 d text,
281 e varchar(20),
282 f int
283 ) engine=ndb;
284 insert into t1 select * from t1old;
285 select count(*) from t1 x, t1old y
286 where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f;
287 count(*)
288 256
289 # run backup
290 drop table t1;
291 create table t1 (
292 e varchar(20),
293 f int,
294 a int unsigned primary key auto_increment,
295 b varchar(8000) character set latin1,
296 c text,
297 d text
298 ) engine=ndb;
299 # run restore
300 select count(*) from t1 x, t1old y
301 where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f;
302 count(*)
303 256
304 drop table t1;
305 # restore disk->disk
306 create table t1 (
307 a int unsigned primary key auto_increment,
308 b text,
309 c varchar(8000) character set latin1,
310 d text,
311 e varchar(20),
312 f int
313 ) engine=ndb tablespace ts1 storage disk;
314 insert into t1 select * from t1old;
315 select count(*) from t1 x, t1old y
316 where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f;
317 count(*)
318 256
319 # run backup
320 drop table t1;
321 create table t1 (
322 e varchar(20),
323 f int,
324 a int unsigned primary key auto_increment,
325 b varchar(8000) character set latin1,
326 c text,
327 d text
328 ) engine=ndb tablespace ts1 storage disk;
329 # run restore
330 select count(*) from t1 x, t1old y
331 where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f;
332 count(*)
333 256
334 drop table t1;
335 drop table t1old;
336 # bug#17235051 : hybrid failure
337 create table t1 (
338 a int primary key,
339 b varchar(5000),
340 c varchar(5000)
341 ) engine=ndb character set latin1;
342 insert into t1 values (1,null,null);
343 select * from t1;
344 a b c
345 1 NULL NULL
346 # run backup
347 drop table t1;
348 create table t1 (
349 a int primary key,
350 b text,
351 c varchar(10000) character set latin1
352 ) engine=ndb;
353 # run restore
354 select * from t1;
355 a b c
356 1 NULL NULL
357 drop table t1;
358 # Ignore dynamic column diffs between staging and 'main'
359 # If backed-up had dynamic (due to online alter), and
360 # new does not (due to lack of alter), staging table
361 # should not care.
362 create table t1(
363 a int unsigned primary key,
364 b varchar(6144) character set latin1
365 ) engine=ndb;
366 # alter causing varchar to become 'dynamic'
367 alter table t1 add column c int;
368 Warnings:
369 Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
370 show warnings;
371 Level Code Message
372 Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
373 insert into t1 values (1,repeat('b',2000), 10);
374 insert into t1 values (2,repeat('t',2000), 20);
375 insert into t1 values (3,repeat('g',2000), 30);
376 # run backup
377 rename table t1 to t1old;
378 # create t1 with text + without alter (not dynamic by default)
379 create table t1(
380 a int unsigned primary key,
381 b text,
382 c int
383 ) engine=ndb;
384 # run restore
385 select count(*) from t1 x, t1old y
386 where x.a = y.a and x.b = y.b and x.c = y.c;
387 count(*)
388 3
389 drop table t1old;
390 drop table t1;
391 # bug#18875137: ndb_restore type conversions
392 # run restore with lossy conversions
393 create table text2text (pk int primary key,
394 t1 tinytext, t2 text, t3 mediumtext, t4 longtext,
395 t5 tinytext, t6 text, t7 mediumtext, t8 longtext,
396 t9 tinytext, t10 text, t11 mediumtext, t12 longtext,
397 t13 tinytext, t14 text, t15 mediumtext, t16 longtext)engine=NDB;
398 insert into text2text values(1,
399 REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65536), REPEAT("A", 30000),
400 REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65537), REPEAT("A", 30000),
401 REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65540), REPEAT("A", 30000),
402 NULL, NULL, NULL, NULL);
403 insert into text2text values(2, "", "", "", "", "", "", "", "", "", "", "", "", NULL, NULL, NULL, NULL);
404 insert into text2text values(3,
405 REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2000), REPEAT(" -,.;", 6000),
406 REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2001), REPEAT(" -,.;", 6000),
407 REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2002), REPEAT(" -,.;", 6000),
408 NULL, NULL, NULL, NULL);
409 insert into text2text values(4,
410 REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2000), REPEAT("12345", 6000),
411 REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2001), REPEAT("12345", 6000),
412 REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2002), REPEAT("12345", 6000),
413 NULL, NULL, NULL, NULL);
414 insert into text2text values(5,
415 REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2000), REPEAT("abcde", 6000),
416 REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2001), REPEAT("abcde", 6000),
417 REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2002), REPEAT("abcde", 6000),
418 NULL, NULL, NULL, NULL);
419 insert into text2text values(6,
420 REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2000), REPEAT(" ", 6000),
421 REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2001), REPEAT(" ", 6000),
422 REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2002), REPEAT(" ", 6000),
423 NULL, NULL, NULL, NULL);
424 insert into text2text values(7,
425 REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2000), REPEAT("a%d4 ", 6000),
426 REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2001), REPEAT("a%d4 ", 6000),
427 REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2002), REPEAT("a%d4 ", 6000),
428 NULL, NULL, NULL, NULL);
429 insert into text2text values(8,
430 NULL, NULL, NULL, NULL,
431 NULL, NULL, NULL, NULL,
432 NULL, NULL, NULL, NULL,
433 NULL, NULL, NULL, NULL);
434 # run backup
435 drop table text2text;
436 create table text2text (pk int primary key,
437 t1 text, t2 mediumtext, t3 longtext, t4 tinytext,
438 t5 mediumtext, t6 longtext, t7 tinytext, t8 text,
439 t9 longtext, t10 tinytext, t11 text, t12 mediumtext,
440 t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB;
441 # run restore
442 # run ndb_select_all to print restored table
443 pk t1 t2 t3 t4 t5 t6 t7 t8 t9 t10 t11 t12 t13 t14 t15 t16
444 1 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65536:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65540:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA [NULL] [NULL] [NULL] [NULL]
445 2 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: [NULL] [NULL] [NULL] [NULL]
446 3 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10010: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; [NULL] [NULL] [NULL] [NULL]
447 4 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10010:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 [NULL] [NULL] [NULL] [NULL]
448 5 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10010:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea [NULL] [NULL] [NULL] [NULL]
449 6 255: 5000: 10000: 256: 255: 5000: 256: 30000: 255: 256: 10010: 30000: [NULL] [NULL] [NULL] [NULL]
450 7 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10010:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a [NULL] [NULL] [NULL] [NULL]
451 8 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL]
452 8 rows returned
453 # run select query to see truncation in mysqld
454 select LENGTH(t1), LENGTH(t2), LENGTH(t3), LENGTH(t4), LENGTH(t5), LENGTH(t6), LENGTH(t7), LENGTH(t8), LENGTH(t9), LENGTH(t10), LENGTH(t11), LENGTH(t12) from text2text order by pk;
455 LENGTH(t1) LENGTH(t2) LENGTH(t3) LENGTH(t4) LENGTH(t5) LENGTH(t6) LENGTH(t7) LENGTH(t8) LENGTH(t9) LENGTH(t10) LENGTH(t11) LENGTH(t12)
456 255 5000 65536 255 255 5000 255 30000 255 255 65535 30000
457 0 0 0 0 0 0 0 0 0 0 0 0
458 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000
459 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000
460 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000
461 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000
462 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000
463 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
464 Warnings:
465 Warning 1265 Truncated value from TEXT field 't4'
466 Warning 1265 Truncated value from TEXT field 't7'
467 Warning 1265 Truncated value from TEXT field 't10'
468 Warning 1265 Truncated value from TEXT field 't11'
469 Warning 1265 Truncated value from TEXT field 't4'
470 Warning 1265 Truncated value from TEXT field 't7'
471 Warning 1265 Truncated value from TEXT field 't10'
472 Warning 1265 Truncated value from TEXT field 't4'
473 Warning 1265 Truncated value from TEXT field 't7'
474 Warning 1265 Truncated value from TEXT field 't10'
475 Warning 1265 Truncated value from TEXT field 't4'
476 Warning 1265 Truncated value from TEXT field 't7'
477 Warning 1265 Truncated value from TEXT field 't10'
478 Warning 1265 Truncated value from TEXT field 't4'
479 Warning 1265 Truncated value from TEXT field 't7'
480 Warning 1265 Truncated value from TEXT field 't10'
481 Warning 1265 Truncated value from TEXT field 't4'
482 Warning 1265 Truncated value from TEXT field 't7'
483 Warning 1265 Truncated value from TEXT field 't10'
484 # run restore with no lossy conversions
485 drop table text2text;
486 create table text2text (pk int primary key,
487 t1 text, t2 mediumtext, t3 longtext, t4 tinytext,
488 t5 mediumtext, t6 longtext, t7 tinytext, t8 text,
489 t9 longtext, t10 tinytext, t11 text, t12 mediumtext,
490 t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB;
491 # run restore
492 # ndb_restore fails with error 1
493 # ndb_restore fails with error 1
494 # restore NULL values into non-nullable columns
495 drop table text2text;
496 create table text2text (pk int primary key,
497 t1 text not null, t2 mediumtext not null, t3 longtext not null, t4 tinytext not null,
498 t5 mediumtext not null, t6 longtext not null, t7 tinytext not null, t8 text not null,
499 t9 longtext not null, t10 tinytext not null, t11 text not null, t12 mediumtext not null,
500 t13 text not null, t14 mediumtext not null, t15 longtext not null, t16 tinytext not null)engine=NDB;
501 # run restore
502 # ndb_restore fails with error 1, staging table suffixes 'ST1-<id>' depend upon total #ldms
503 # ndb_restore fails with error 1, staging table suffixes 'ST1-<id>' depend upon total #ldms
504 # restore to text column with different charset
505 drop table text2text;
506 create table text2text (pk int primary key,
507 t1 text character set utf8, t2 mediumtext character set utf8, t3 longtext character set utf8, t4 tinytext character set utf8,
508 t5 mediumtext character set utf8, t6 longtext character set utf8, t7 tinytext character set utf8, t8 text character set utf8,
509 t9 longtext character set utf8, t10 tinytext character set utf8, t11 text character set utf8, t12 mediumtext character set utf8,
510 t13 text character set utf8, t14 mediumtext character set utf8, t15 longtext character set utf8, t16 tinytext character set utf8)engine=NDB;
511 Warnings:
512 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
513 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
514 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
515 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
516 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
517 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
518 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
519 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
520 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
521 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
522 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
523 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
524 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
525 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
526 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
527 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
528 # run restore
529 # ndb_restore fails with error 1
530 # ndb_restore fails with error 1
531 # restore with mix of staging and built-in conversions
532 drop table text2text;
533 create table text2text (pk mediumint primary key,
534 t1 text, t2 mediumtext, t3 longtext, t4 tinytext,
535 t5 mediumtext, t6 longtext, t7 tinytext, t8 text,
536 t9 longtext, t10 tinytext, t11 text, t12 mediumtext,
537 t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB;
538 # run restore
539 # run ndb_select_all to print restored table
540 pk t1 t2 t3 t4 t5 t6 t7 t8 t9 t10 t11 t12 t13 t14 t15 t16
541 1 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65536:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65540:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA [NULL] [NULL] [NULL] [NULL]
542 2 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: [NULL] [NULL] [NULL] [NULL]
543 3 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10010: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; [NULL] [NULL] [NULL] [NULL]
544 4 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10010:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 [NULL] [NULL] [NULL] [NULL]
545 5 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10010:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea [NULL] [NULL] [NULL] [NULL]
546 6 255: 5000: 10000: 256: 255: 5000: 256: 30000: 255: 256: 10010: 30000: [NULL] [NULL] [NULL] [NULL]
547 7 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10010:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a [NULL] [NULL] [NULL] [NULL]
548 8 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL]
549 8 rows returned
550 drop table text2text;
551 # restore with pk built-in conversion and blob staging conversion
552 create table text2text(id char(10) character set latin1 primary key, val text)engine=ndb;
553 insert into text2text values("1111111111", REPEAT("A", 500));
554 insert into text2text values("2222222222", REPEAT("B", 500));
555 # run backup
556 drop table text2text;
557 create table text2text(id varchar(5) character set latin1 primary key, val mediumtext)engine=ndb;
558 # run restore
559 # run ndb_select_all to print restored table
560 id val
561 "11111" 500:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
562 "22222" 500:BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
563 2 rows returned
564 # ndb_restore TEXT -> TINYTEXT truncation with utf8
565 drop table text2text;
566 set character_set_client=utf8;
567 Warnings:
568 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
569 create table text2text(id int primary key, val text character set utf8)engine=ndb;
570 Warnings:
571 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
572 insert into text2text values(11111, REPEAT(UNHEX("E38182"), 100));
573 insert into text2text values(22222, CONCAT("A",REPEAT(UNHEX("E38182"), 100)));
574 # run backup
575 drop table text2text;
576 create table text2text(id int primary key, val tinytext character set utf8)engine=ndb;
577 Warnings:
578 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
579 # run restore
580 # run ndb_select_all to see charset-aware truncation in ndb
581 id val
582 11111 255:あああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああ
583 22222 256:Aあああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああ
584 2 rows returned
585 # run mysql select to see charset-aware truncation in mysqld
586 # truncation in pk-based read
587 select length(val), char_length(val) from text2text where id = 22222;
588 length(val) char_length(val)
589 253 85
590 Warnings:
591 Warning 1265 Truncated value from TEXT field 'val'
592 # truncation in scan
593 select length(val), char_length(val) from text2text order by id;
594 length(val) char_length(val)
595 255 85
596 253 85
597 Warnings:
598 Warning 1265 Truncated value from TEXT field 'val'
599 drop table text2text;
600 # drop tablespace
601 alter tablespace ts1
602 drop datafile 'datafile1.dat';
603 drop tablespace ts1;
604 drop logfile group lg1
605 engine=ndb;