Debian Codegraph @

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

raw
1 use test;
2 create table test.t1 (a varchar(20) not null,
3 b varchar(20) not null,
4 c varchar(20),
5 d varchar(20),
6 e text,
7 primary key(a,b)) engine=ndb;
8 insert into test.t1 values
9 ("1a","1b",NULL,"1d", repeat('01WIFUA',1000)),
10 ("2a","2b",NULL,"2d", repeat('02WIFUA',1000)),
11 ("3a","3b",NULL,"3d", repeat('03WIFUA',1000)),
12 ("4a","4b",NULL,"4d", repeat('04WIFUA',1000)),
13 ("5a","5b",NULL,"5d", repeat('05WIFUA',1000)),
14 ("6a","6b",NULL,"6d", repeat('06WIFUA',1000)),
15 ("7a","7b",NULL,"7d", repeat('07WIFUA',1000)),
16 ("8a","8b",NULL,"8d", repeat('08WIFUA',1000)),
17 ("9a","9b",NULL,"9d", repeat('09WIFUA',1000)),
18 ("10a","10b",NULL,"10d", repeat('10WIFUA',1000)),
19 ("11a","11b",NULL,"11d", repeat('11WIFUA',1000)),
20 ("12a","12b",NULL,"12d", repeat('12WIFUA',1000)),
21 ("13a","13b",NULL,"13d", repeat('13WIFUA',1000)),
22 ("14a","14b",NULL,"14d", repeat('14WIFUA',1000)),
23 ("15a","15b",NULL,"15d", repeat('15WIFUA',1000)),
24 ("16a","16b",NULL,"16d", repeat('16WIFUA',1000));
25 Stall backup completion
26 Run backup
27 Starting backup
28 Backup started
29 Make some changes which will be logged...
30 insert into test.t1 values
31 ("17a","17b",NULL,"17d", repeat('17WIFUA',1000)),
32 ("18a","18b",NULL,"18d", repeat('18WIFUA',1000)),
33 ("19a","19b",NULL,"19d", repeat('19WIFUA',1000));
34 update test.t1 set d=concat(d, "-modified");
35 delete from test.t1 where a in ("5a","18a");
36 Allow backup to complete...
37 Waiting for backup to complete
38 Backup completed
39 delete from test.t1;
40 # Normal restore using slices
41 select a,b,c,d,length(e), right(e, 7) from test.t1 order by a,b;
42 a b c d length(e) right(e, 7)
43 10a 10b NULL 10d-modified 7000 10WIFUA
44 11a 11b NULL 11d-modified 7000 11WIFUA
45 12a 12b NULL 12d-modified 7000 12WIFUA
46 13a 13b NULL 13d-modified 7000 13WIFUA
47 14a 14b NULL 14d-modified 7000 14WIFUA
48 15a 15b NULL 15d-modified 7000 15WIFUA
49 16a 16b NULL 16d-modified 7000 16WIFUA
50 17a 17b NULL 17d-modified 7000 17WIFUA
51 19a 19b NULL 19d-modified 7000 19WIFUA
52 1a 1b NULL 1d-modified 7000 01WIFUA
53 2a 2b NULL 2d-modified 7000 02WIFUA
54 3a 3b NULL 3d-modified 7000 03WIFUA
55 4a 4b NULL 4d-modified 7000 04WIFUA
56 6a 6b NULL 6d-modified 7000 06WIFUA
57 7a 7b NULL 7d-modified 7000 07WIFUA
58 8a 8b NULL 8d-modified 7000 08WIFUA
59 9a 9b NULL 9d-modified 7000 09WIFUA
60 drop table test.t1;
61 # Restore with staging conversions + slices
62 create table test.t1 (a varchar(20) not null,
63 b varchar(20) not null,
64 c text,
65 d text,
66 e text,
67 primary key(a,b)) engine=ndb;
68 select a,b,c,d,length(e), right(e, 7) from test.t1 order by a,b;
69 a b c d length(e) right(e, 7)
70 10a 10b NULL 10d-modified 7000 10WIFUA
71 11a 11b NULL 11d-modified 7000 11WIFUA
72 12a 12b NULL 12d-modified 7000 12WIFUA
73 13a 13b NULL 13d-modified 7000 13WIFUA
74 14a 14b NULL 14d-modified 7000 14WIFUA
75 15a 15b NULL 15d-modified 7000 15WIFUA
76 16a 16b NULL 16d-modified 7000 16WIFUA
77 17a 17b NULL 17d-modified 7000 17WIFUA
78 19a 19b NULL 19d-modified 7000 19WIFUA
79 1a 1b NULL 1d-modified 7000 01WIFUA
80 2a 2b NULL 2d-modified 7000 02WIFUA
81 3a 3b NULL 3d-modified 7000 03WIFUA
82 4a 4b NULL 4d-modified 7000 04WIFUA
83 6a 6b NULL 6d-modified 7000 06WIFUA
84 7a 7b NULL 7d-modified 7000 07WIFUA
85 8a 8b NULL 8d-modified 7000 08WIFUA
86 9a 9b NULL 9d-modified 7000 09WIFUA
87 drop table test.t1;