Debian Codegraph @

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

raw
1 Case 1: single-threaded backup + single-threaded restore
2 "Create tables for backup"
3 Warnings:
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 Integer display width 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 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
12 Warning 1681 Integer display width is deprecated and will be removed in a future release.
13 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.
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 Warning 1681 Integer display width is deprecated and will be removed in a future release.
18
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 "Restoring metadata"
28 "Restoring backup on node 1"
29 "Restoring backup on node 2"
30 "Print restored rows"
31 use test;
32 select * from t0 order by id;
33 id val
34 1 1
35 2 2
36 3 3
37 4 4
38 5 5
39 6 6
40 7 7
41 8 8
42 9 9
43 10 12345
44 select * from t1 order by val;
45 val
46 NULL
47 2
48 3
49 4
50 5
51 6
52 7
53 8
54 9
55 11
56 select * from t2 order by id;
57 id
58 1
59 3
60 4
61 5
62 6
63 7
64 8
65 9
66 10
67 22
68 select * from t3 order by id;
69 id val
70 1 9
71 2 8
72 3 33
73 4 6
74 5 5
75 6 4
76 7 3
77 8 2
78 9 1
79 10 NULL
80 select * from t4 order by id;
81 id val
82 1 11001
83 2 11001
84 3 11001
85 4 44
86 5 11001
87 6 11001
88 7 11001
89 8 11001
90 9 11001
91 10 11001
92 select id, sha1(val) from t5 order by id;
93 id sha1(val)
94 1 0b35a3e0949353117c55151be416c64481dc9778
95 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
96 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
97 4 ea7dffff542a062f6e41c69afac9576d7e97634c
98 5 266d8973914802f093f698a58224566ca2a664bc
99 6 4a8284d4be6c4c063a910760610c8754ca1234a3
100 7 c1bd312a4dd67884e66d15671d38c854e99c8021
101 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
102 9 139101d8480a9a68e4e1256ed300aad365725fbc
103 10 NULL
104 select * from t6 order by id;
105 id val
106 1 1
107 2 2
108 3 3
109 4 4
110 5 5
111 6 66
112 7 7
113 8 8
114 9 9
115 10 NULL
116 select * from t7 order by id;
117 id val1 val2
118 1 9 9
119 2 8 8
120 3 7 7
121 4 6 6
122 5 5 5
123 6 4 4
124 7 77 3
125 8 2 2
126 9 1 1
127 10 10 NULL
128 select id, sha1(val) from t8 order by id;
129 id sha1(val)
130 1 025bd54db3f70cdac283a9653518c14f3d331602
131 2 360252745cb517637959a9ba6cb7a789cf05fa98
132 3 e315b8015984d48b3d1777787d8b629bd77454cf
133 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
134 5 66f223928b25272f115396aa099fb38efbfe3885
135 6 125d03fac5bb972ef45466e36d25fd219bf09b36
136 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
137 8 61984ed58e8de9ab388e62b54ced499e7336e82e
138 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
139 10 NULL
140 select * from t9 order by auto;
141 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
142 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
143 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
144 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
145 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
146 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
147 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
148 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
149 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
150 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
151 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL
152 "Drop tables after backup completes"
153 Case 2: single-threaded snapshotstart backup + single-threaded restore
154 "Create tables for backup"
155 Warnings:
156 Warning 1681 Integer display width is deprecated and will be removed in a future release.
157 Warning 1681 Integer display width is deprecated and will be removed in a future release.
158 Warning 1681 Integer display width is deprecated and will be removed in a future release.
159 Warning 1681 Integer display width is deprecated and will be removed in a future release.
160 Warning 1681 Integer display width is deprecated and will be removed in a future release.
161 Warning 1681 Integer display width is deprecated and will be removed in a future release.
162 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
163 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
164 Warning 1681 Integer display width is deprecated and will be removed in a future release.
165 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.
166 Warning 1681 Integer display width is deprecated and will be removed in a future release.
167 Warning 1681 Integer display width is deprecated and will be removed in a future release.
168 Warning 1681 Integer display width is deprecated and will be removed in a future release.
169 Warning 1681 Integer display width is deprecated and will be removed in a future release.
170
171 Starting SNAPSHOTSTART backup
172 Backup started
173 "Update tables during backup"
174
175 "Wait for backup to complete"
176 Waiting for backup to complete
177 Backup completed
178 "Drop tables after backup completes"
179 "Restoring metadata"
180 "Restoring backup on node 1"
181 "Restoring backup on node 2"
182 "Print restored rows"
183 use test;
184 select * from t0 order by id;
185 id val
186 1 1
187 2 2
188 3 3
189 4 4
190 5 5
191 6 6
192 7 7
193 8 8
194 9 9
195 10 NULL
196 select * from t1 order by val;
197 val
198 NULL
199 1
200 2
201 3
202 4
203 5
204 6
205 7
206 8
207 9
208 select * from t2 order by id;
209 id
210 1
211 2
212 3
213 4
214 5
215 6
216 7
217 8
218 9
219 10
220 select * from t3 order by id;
221 id val
222 1 9
223 2 8
224 3 7
225 4 6
226 5 5
227 6 4
228 7 3
229 8 2
230 9 1
231 10 NULL
232 select * from t4 order by id;
233 id val
234 1 11001
235 2 11001
236 3 11001
237 4 11001
238 5 11001
239 6 11001
240 7 11001
241 8 11001
242 9 11001
243 10 11001
244 select id, sha1(val) from t5 order by id;
245 id sha1(val)
246 1 0b35a3e0949353117c55151be416c64481dc9778
247 2 0f5f3d3783159438eff81e6b3c8911480daf7eac
248 3 7b48e60fd747fc37363da73d3140ba0a41ae862a
249 4 ea7dffff542a062f6e41c69afac9576d7e97634c
250 5 8a96558c6361531c5f387582e5f6cd732332262b
251 6 4a8284d4be6c4c063a910760610c8754ca1234a3
252 7 c1bd312a4dd67884e66d15671d38c854e99c8021
253 8 d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
254 9 139101d8480a9a68e4e1256ed300aad365725fbc
255 10 NULL
256 select * from t6 order by id;
257 id val
258 1 1
259 2 2
260 3 3
261 4 4
262 5 5
263 6 6
264 7 7
265 8 8
266 9 9
267 10 NULL
268 select * from t7 order by id;
269 id val1 val2
270 1 9 9
271 2 8 8
272 3 7 7
273 4 6 6
274 5 5 5
275 6 4 4
276 7 3 3
277 8 2 2
278 9 1 1
279 10 10 NULL
280 select id, sha1(val) from t8 order by id;
281 id sha1(val)
282 1 025bd54db3f70cdac283a9653518c14f3d331602
283 2 360252745cb517637959a9ba6cb7a789cf05fa98
284 3 e315b8015984d48b3d1777787d8b629bd77454cf
285 4 946a83f98e3f05c3d94f0c7f2e7131324245797c
286 5 66f223928b25272f115396aa099fb38efbfe3885
287 6 125d03fac5bb972ef45466e36d25fd219bf09b36
288 7 cf47dcc87c1ca726f74a86a4aac57d453703facc
289 8 f8f5538687ac9a4294a44de553d46dd798524504
290 9 ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
291 10 NULL
292 select * from t9 order by auto;
293 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
294 1 9999 9999 -9 -9 -9 -9 -9 9.9 9.9000 9.9000 9 00009 9 9 9  one one 1999-09-09 1999 09:09:09 1999-09-09 09:09:09
295 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
296 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
297 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
298 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
299 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
300 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
301 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
302 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
303 10 NULL NULL 10 10 10 10 10 10.1 NULL NULL 10 00010 10 10 10 NULL two two NULL NULL NULL NULL
304 "Drop tables after backup completes"
305 Case 3: start backup wait completed