Debian Codegraph @

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

raw
1 "Create tables for backup"
2 Warnings:
3 Warning 1681 Integer display width is deprecated and will be removed in a future release.
4 Warning 1681 Integer display width is deprecated and will be removed in a future release.
5 Warning 1681 Integer display width is deprecated and will be removed in a future release.
6 Warning 1681 Integer display width is deprecated and will be removed in a future release.
7 Warning 1681 Integer display width is deprecated and will be removed in a future release.
8 Warning 1681 Integer display width is deprecated and will be removed in a future release.
9 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
10 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
11 Warning 1681 Integer display width is deprecated and will be removed in a future release.
12 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
13 Warning 1681 Integer display width is deprecated and will be removed in a future release.
14 Warning 1681 Integer display width is deprecated and will be removed in a future release.
15 Warning 1681 Integer display width is deprecated and will be removed in a future release.
16 Warning 1681 Integer display width is deprecated and will be removed in a future release.
17
18 "Starting backup as nowait"
19 Starting backup
20 Backup started
21 "Update tables during backup"
22
23 "Wait for backup to complete"
24 Waiting for backup to complete
25 Backup completed
26 "Drop tables after backup completes"
27 Restore metadata using backup-part 1
28 Restore data by restoring all backup parts serially
29 Restore data of PART-12-OF-12 on node 6
30 Restore data of PART-11-OF-12 on node 6
31 Restore data of PART-10-OF-12 on node 6
32 Restore data of PART-9-OF-12 on node 6
33 Restore data of PART-8-OF-12 on node 6
34 Restore data of PART-7-OF-12 on node 6
35 Restore data of PART-6-OF-12 on node 6
36 Restore data of PART-5-OF-12 on node 6
37 Restore data of PART-4-OF-12 on node 6
38 Restore data of PART-3-OF-12 on node 6
39 Restore data of PART-2-OF-12 on node 6
40 Restore data of PART-1-OF-12 on node 6
41 Restore data of PART-10-OF-10 on node 5
42 Restore data of PART-9-OF-10 on node 5
43 Restore data of PART-8-OF-10 on node 5
44 Restore data of PART-7-OF-10 on node 5
45 Restore data of PART-6-OF-10 on node 5
46 Restore data of PART-5-OF-10 on node 5
47 Restore data of PART-4-OF-10 on node 5
48 Restore data of PART-3-OF-10 on node 5
49 Restore data of PART-2-OF-10 on node 5
50 Restore data of PART-1-OF-10 on node 5
51 Restore data of PART-8-OF-8 on node 4
52 Restore data of PART-7-OF-8 on node 4
53 Restore data of PART-6-OF-8 on node 4
54 Restore data of PART-5-OF-8 on node 4
55 Restore data of PART-4-OF-8 on node 4
56 Restore data of PART-3-OF-8 on node 4
57 Restore data of PART-2-OF-8 on node 4
58 Restore data of PART-1-OF-8 on node 4
59 Restore data of PART-6-OF-6 on node 3
60 Restore data of PART-5-OF-6 on node 3
61 Restore data of PART-4-OF-6 on node 3
62 Restore data of PART-3-OF-6 on node 3
63 Restore data of PART-2-OF-6 on node 3
64 Restore data of PART-1-OF-6 on node 3
65 Restore data of PART-4-OF-4 on node 2
66 Restore data of PART-3-OF-4 on node 2
67 Restore data of PART-2-OF-4 on node 2
68 Restore data of PART-1-OF-4 on node 2
69 Restore data of PART-2-OF-2 on node 1
70 Restore data of PART-1-OF-2 on node 1
71 "Print restored rows"
72 use test;
73 select * from t0 order by id;
74 id val
75 1 1
76 2 2
77 3 3
78 4 4
79 5 5
80 6 6
81 7 7
82 8 8
83 9 9
84 10 12345
85 select * from t1 order by val;
86 val
87 NULL
88 2
89 3
90 4
91 5
92 6
93 7
94 8
95 9
96 11
97 select * from t2 order by id;
98 id
99 1
100 3
101 4
102 5
103 6
104 7
105 8
106 9
107 10
108 22
109 select * from t3 order by id;
110 id val
111 1 9
112 2 8
113 3 33
114 4 6
115 5 5
116 6 4
117 7 3
118 8 2
119 9 1
120 10 NULL
121 select * from t4 order by id;
122 id val
123 1 11001
124 2 11001
125 3 11001
126 4 44
127 5 11001
128 6 11001
129 7 11001
130 8 11001
131 9 11001
132 10 11001
133 select id, sha1(val) from t5 order by id;
134 id sha1(val)
135 1 0b35a3e0949353117c55151be416c64481dc9778
136 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
137 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
138 4 ea7dffff542a062f6e41c69afac9576d7e97634c
139 5 266d8973914802f093f698a58224566ca2a664bc
140 6 4a8284d4be6c4c063a910760610c8754ca1234a3
141 7 c1bd312a4dd67884e66d15671d38c854e99c8021
142 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
143 9 139101d8480a9a68e4e1256ed300aad365725fbc
144 10 NULL
145 select * from t6 order by id;
146 id val
147 1 1
148 2 2
149 3 3
150 4 4
151 5 5
152 6 66
153 7 7
154 8 8
155 9 9
156 10 NULL
157 select * from t7 order by id;
158 id val1 val2
159 1 9 9
160 2 8 8
161 3 7 7
162 4 6 6
163 5 5 5
164 6 4 4
165 7 77 3
166 8 2 2
167 9 1 1
168 10 10 NULL
169 select id, sha1(val) from t8 order by id;
170 id sha1(val)
171 1 fd7d9e6b83b0d8c82065d03cb3aa7fd9004b1be3
172 2 bc6d3732391be0cf937c126aedd201348b77eb73
173 3 558ea7eaf6bc169cf132d8b79fa3cb24d256b43d
174 4 b940efa7f439709e3a9f6f7ae7a139a0ffc4615c
175 5 28f701601814c80158537b932009ee46e2f7ceda
176 6 7aaa4f2845f274d843997517f64e0f613cbb8439
177 7 d13462051501e81028a3aafcf1359af394493cba
178 8 b37f6ddcefad7e8657837d3177f9ef2462f98acf
179 9 26dd2ef1ebb5fa7958eccce47d8f71257642a207
180 10 NULL
181 select * from t9 order by auto;
182 auto string vstring tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
183 1 bbbb bbbb -22 -22 -22 -22 -22 22.2 22.2200 22.2200 22 00022 22 22 22  two two 1922-02-22 1922 22:22:22 1922-02-22 22:22:22
184 2 8888 8888 -8 -8 -8 -8 -8 8.8 8.8000 8.8000 8 00008 8 8 8  one one 1988-08-08 1988 08:08:08 1988-08-08 08:08:08
185 3 7777 7777 -7 -7 -7 -7 -7 7.7 7.7000 7.7000 7 00007 7 7 7  one one 1977-07-07 1977 07:07:07 1977-07-07 07:07:07
186 4 6666 6666 -6 -6 -6 -6 -6 6.6 6.6000 6.6000 6 00006 6 6 6  one one 1966-06-06 1966 06:06:06 1966-06-06 06:06:06
187 5 5555 5555 -5 -5 -5 -5 -5 5.5 5.5000 5.5000 5 00005 5 5 5  one one 1955-05-05 1955 05:05:05 1955-05-05 05:05:05
188 6 4444 4444 -4 -4 -4 -4 -4 4.4 4.4000 4.4000 4 00004 4 4 4  one one 1944-04-04 1944 04:04:04 1944-04-04 04:04:04
189 7 3333 3333 -3 -3 -3 -3 -3 3.3 3.3000 3.3000 3 00003 3 3 3  one one 1933-03-03 1933 03:03:03 1933-03-03 03:03:03
190 8 2222 2222 -2 -2 -2 -2 -2 2.2 2.2000 2.2000 2 00002 2 2 2  one one 1922-02-02 1922 02:02:02 1922-02-02 02:02:02
191 9 1111 1111 -1 -1 -1 -1 -1 1.1 1.1000 1.1000 1 00001 1 1 1  one one 1911-01-01 1911 01:01:01 1911-01-01 01:01:01
192 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL
193 Drop all tables
194 Restore metadata using mt-restore
195 Restore data using mt-restore of all backup parts
196 "Print restored rows"
197 use test;
198 select * from t0 order by id;
199 id val
200 1 1
201 2 2
202 3 3
203 4 4
204 5 5
205 6 6
206 7 7
207 8 8
208 9 9
209 10 12345
210 select * from t1 order by val;
211 val
212 NULL
213 2
214 3
215 4
216 5
217 6
218 7
219 8
220 9
221 11
222 select * from t2 order by id;
223 id
224 1
225 3
226 4
227 5
228 6
229 7
230 8
231 9
232 10
233 22
234 select * from t3 order by id;
235 id val
236 1 9
237 2 8
238 3 33
239 4 6
240 5 5
241 6 4
242 7 3
243 8 2
244 9 1
245 10 NULL
246 select * from t4 order by id;
247 id val
248 1 11001
249 2 11001
250 3 11001
251 4 44
252 5 11001
253 6 11001
254 7 11001
255 8 11001
256 9 11001
257 10 11001
258 select id, sha1(val) from t5 order by id;
259 id sha1(val)
260 1 0b35a3e0949353117c55151be416c64481dc9778
261 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
262 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
263 4 ea7dffff542a062f6e41c69afac9576d7e97634c
264 5 266d8973914802f093f698a58224566ca2a664bc
265 6 4a8284d4be6c4c063a910760610c8754ca1234a3
266 7 c1bd312a4dd67884e66d15671d38c854e99c8021
267 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
268 9 139101d8480a9a68e4e1256ed300aad365725fbc
269 10 NULL
270 select * from t6 order by id;
271 id val
272 1 1
273 2 2
274 3 3
275 4 4
276 5 5
277 6 66
278 7 7
279 8 8
280 9 9
281 10 NULL
282 select * from t7 order by id;
283 id val1 val2
284 1 9 9
285 2 8 8
286 3 7 7
287 4 6 6
288 5 5 5
289 6 4 4
290 7 77 3
291 8 2 2
292 9 1 1
293 10 10 NULL
294 select id, sha1(val) from t8 order by id;
295 id sha1(val)
296 1 fd7d9e6b83b0d8c82065d03cb3aa7fd9004b1be3
297 2 bc6d3732391be0cf937c126aedd201348b77eb73
298 3 558ea7eaf6bc169cf132d8b79fa3cb24d256b43d
299 4 b940efa7f439709e3a9f6f7ae7a139a0ffc4615c
300 5 28f701601814c80158537b932009ee46e2f7ceda
301 6 7aaa4f2845f274d843997517f64e0f613cbb8439
302 7 d13462051501e81028a3aafcf1359af394493cba
303 8 b37f6ddcefad7e8657837d3177f9ef2462f98acf
304 9 26dd2ef1ebb5fa7958eccce47d8f71257642a207
305 10 NULL
306 select * from t9 order by auto;
307 auto string vstring tiny short medium long_int longlong real_float real_double real_decimal utiny ushort umedium ulong ulonglong bits options flags date_field year_field time_field date_time
308 1 bbbb bbbb -22 -22 -22 -22 -22 22.2 22.2200 22.2200 22 00022 22 22 22  two two 1922-02-22 1922 22:22:22 1922-02-22 22:22:22
309 2 8888 8888 -8 -8 -8 -8 -8 8.8 8.8000 8.8000 8 00008 8 8 8  one one 1988-08-08 1988 08:08:08 1988-08-08 08:08:08
310 3 7777 7777 -7 -7 -7 -7 -7 7.7 7.7000 7.7000 7 00007 7 7 7  one one 1977-07-07 1977 07:07:07 1977-07-07 07:07:07
311 4 6666 6666 -6 -6 -6 -6 -6 6.6 6.6000 6.6000 6 00006 6 6 6  one one 1966-06-06 1966 06:06:06 1966-06-06 06:06:06
312 5 5555 5555 -5 -5 -5 -5 -5 5.5 5.5000 5.5000 5 00005 5 5 5  one one 1955-05-05 1955 05:05:05 1955-05-05 05:05:05
313 6 4444 4444 -4 -4 -4 -4 -4 4.4 4.4000 4.4000 4 00004 4 4 4  one one 1944-04-04 1944 04:04:04 1944-04-04 04:04:04
314 7 3333 3333 -3 -3 -3 -3 -3 3.3 3.3000 3.3000 3 00003 3 3 3  one one 1933-03-03 1933 03:03:03 1933-03-03 03:03:03
315 8 2222 2222 -2 -2 -2 -2 -2 2.2 2.2000 2.2000 2 00002 2 2 2  one one 1922-02-02 1922 02:02:02 1922-02-02 02:02:02
316 9 1111 1111 -1 -1 -1 -1 -1 1.1 1.1000 1.1000 1 00001 1 1 1  one one 1911-01-01 1911 01:01:01 1911-01-01 01:01:01
317 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL