Debian Codegraph @

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

raw
1 create table test.t1 (a int auto_increment primary key, b int) engine=ndb;
2 create table test.t2 (a int primary key, b int) engine=ndb;
3 Table with auto-inc, initial value
4 -- t1 --
5 Database: test
6 Schema: def
7 Name: t1
8 Table id: XXX
9 Version: Any
10 Fragment type: HashMapPartition
11 K Value: 6
12 Min load factor: 78
13 Max load factor: 80
14 Temporary table: no
15 Number of attributes: 2
16 Number of primary keys: 1
17 Length of frm data: XXX
18 Max Rows: 0
19 Row Checksum: 1
20 Row GCI: 1
21 SingleUserMode: 0
22 ForceVarPart: 1
23 PartitionCount: 8
24 FragmentCount: 8
25 PartitionBalance: FOR_RP_BY_LDM
26 ExtraRowGciBits: 0
27 ExtraRowAuthorBits: 0
28 TableStatus: Retrieved
29 Table options: readbackup
30 HashMap: DEFAULT-HASHMAP-3840-8
31 -- Attributes --
32 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
33 b Int NULL AT=FIXED ST=MEMORY
34 -- Indexes --
35 PRIMARY KEY(a) - UniqueHashIndex
36 PRIMARY(a) - OrderedIndex
37 -- AutoIncrement info
38 AutoIncrement: 1
39 insert into test.t1 (b) values (888);
40 select * from test.t1 order by a;
41 a b
42 1 888
43 Table with auto-inc, new value
44 -- t1 --
45 Database: test
46 Schema: def
47 Name: t1
48 Table id: XXX
49 Version: Any
50 Fragment type: HashMapPartition
51 K Value: 6
52 Min load factor: 78
53 Max load factor: 80
54 Temporary table: no
55 Number of attributes: 2
56 Number of primary keys: 1
57 Length of frm data: XXX
58 Max Rows: 0
59 Row Checksum: 1
60 Row GCI: 1
61 SingleUserMode: 0
62 ForceVarPart: 1
63 PartitionCount: 8
64 FragmentCount: 8
65 PartitionBalance: FOR_RP_BY_LDM
66 ExtraRowGciBits: 0
67 ExtraRowAuthorBits: 0
68 TableStatus: Retrieved
69 Table options: readbackup
70 HashMap: DEFAULT-HASHMAP-3840-8
71 -- Attributes --
72 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
73 b Int NULL AT=FIXED ST=MEMORY
74 -- Indexes --
75 PRIMARY KEY(a) - UniqueHashIndex
76 PRIMARY(a) - OrderedIndex
77 -- AutoIncrement info
78 AutoIncrement: 2
79 insert into test.t1 (a,b) values (12345, 888);
80 select * from test.t1 order by a;
81 a b
82 1 888
83 12345 888
84 Table with auto-inc, forced value
85 -- t1 --
86 Database: test
87 Schema: def
88 Name: t1
89 Table id: XXX
90 Version: Any
91 Fragment type: HashMapPartition
92 K Value: 6
93 Min load factor: 78
94 Max load factor: 80
95 Temporary table: no
96 Number of attributes: 2
97 Number of primary keys: 1
98 Length of frm data: XXX
99 Max Rows: 0
100 Row Checksum: 1
101 Row GCI: 1
102 SingleUserMode: 0
103 ForceVarPart: 1
104 PartitionCount: 8
105 FragmentCount: 8
106 PartitionBalance: FOR_RP_BY_LDM
107 ExtraRowGciBits: 0
108 ExtraRowAuthorBits: 0
109 TableStatus: Retrieved
110 Table options: readbackup
111 HashMap: DEFAULT-HASHMAP-3840-8
112 -- Attributes --
113 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
114 b Int NULL AT=FIXED ST=MEMORY
115 -- Indexes --
116 PRIMARY KEY(a) - UniqueHashIndex
117 PRIMARY(a) - OrderedIndex
118 -- AutoIncrement info
119 AutoIncrement: 12346
120 insert into test.t1 (b) values (888);
121 select * from test.t1 order by a;
122 a b
123 1 888
124 12345 888
125 12346 888
126 Table with auto-inc, next value after forced
127 -- t1 --
128 Database: test
129 Schema: def
130 Name: t1
131 Table id: XXX
132 Version: Any
133 Fragment type: HashMapPartition
134 K Value: 6
135 Min load factor: 78
136 Max load factor: 80
137 Temporary table: no
138 Number of attributes: 2
139 Number of primary keys: 1
140 Length of frm data: XXX
141 Max Rows: 0
142 Row Checksum: 1
143 Row GCI: 1
144 SingleUserMode: 0
145 ForceVarPart: 1
146 PartitionCount: 8
147 FragmentCount: 8
148 PartitionBalance: FOR_RP_BY_LDM
149 ExtraRowGciBits: 0
150 ExtraRowAuthorBits: 0
151 TableStatus: Retrieved
152 Table options: readbackup
153 HashMap: DEFAULT-HASHMAP-3840-8
154 -- Attributes --
155 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
156 b Int NULL AT=FIXED ST=MEMORY
157 -- Indexes --
158 PRIMARY KEY(a) - UniqueHashIndex
159 PRIMARY(a) - OrderedIndex
160 -- AutoIncrement info
161 AutoIncrement: 12347
162 drop table test.t1;
163 create table test.t1 (a int auto_increment primary key, b int) engine=ndb;
164 Re-created table with auto-inc, initial value
165 -- t1 --
166 Database: test
167 Schema: def
168 Name: t1
169 Table id: XXX
170 Version: Any
171 Fragment type: HashMapPartition
172 K Value: 6
173 Min load factor: 78
174 Max load factor: 80
175 Temporary table: no
176 Number of attributes: 2
177 Number of primary keys: 1
178 Length of frm data: XXX
179 Max Rows: 0
180 Row Checksum: 1
181 Row GCI: 1
182 SingleUserMode: 0
183 ForceVarPart: 1
184 PartitionCount: 8
185 FragmentCount: 8
186 PartitionBalance: FOR_RP_BY_LDM
187 ExtraRowGciBits: 0
188 ExtraRowAuthorBits: 0
189 TableStatus: Retrieved
190 Table options: readbackup
191 HashMap: DEFAULT-HASHMAP-3840-8
192 -- Attributes --
193 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
194 b Int NULL AT=FIXED ST=MEMORY
195 -- Indexes --
196 PRIMARY KEY(a) - UniqueHashIndex
197 PRIMARY(a) - OrderedIndex
198 -- AutoIncrement info
199 AutoIncrement: 1
200 drop table test.t1;
201 create table test.t1 (a int primary key, b int) engine=ndb;
202 Re-created table with no auto-inc key
203 -- t1 --
204 Database: test
205 Schema: def
206 Name: t1
207 Table id: XXX
208 Version: Any
209 Fragment type: HashMapPartition
210 K Value: 6
211 Min load factor: 78
212 Max load factor: 80
213 Temporary table: no
214 Number of attributes: 2
215 Number of primary keys: 1
216 Length of frm data: XXX
217 Max Rows: 0
218 Row Checksum: 1
219 Row GCI: 1
220 SingleUserMode: 0
221 ForceVarPart: 1
222 PartitionCount: 8
223 FragmentCount: 8
224 PartitionBalance: FOR_RP_BY_LDM
225 ExtraRowGciBits: 0
226 ExtraRowAuthorBits: 0
227 TableStatus: Retrieved
228 Table options: readbackup
229 HashMap: DEFAULT-HASHMAP-3840-8
230 -- Attributes --
231 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
232 b Int NULL AT=FIXED ST=MEMORY
233 -- Indexes --
234 PRIMARY KEY(a) - UniqueHashIndex
235 PRIMARY(a) - OrderedIndex
236 Table with no auto-inc
237 drop table test.t1;
238 drop table test.t2;
239 Show behaviour with a larger autoinc prefetch size
240 set ndb_autoincrement_prefetch_sz = 8;
241 create table test.t3 (a int auto_increment primary key, b int) engine=ndb;
242 Initial value : 1
243 -- t3 --
244 Database: test
245 Schema: def
246 Name: t3
247 Table id: XXX
248 Version: Any
249 Fragment type: HashMapPartition
250 K Value: 6
251 Min load factor: 78
252 Max load factor: 80
253 Temporary table: no
254 Number of attributes: 2
255 Number of primary keys: 1
256 Length of frm data: XXX
257 Max Rows: 0
258 Row Checksum: 1
259 Row GCI: 1
260 SingleUserMode: 0
261 ForceVarPart: 1
262 PartitionCount: 8
263 FragmentCount: 8
264 PartitionBalance: FOR_RP_BY_LDM
265 ExtraRowGciBits: 0
266 ExtraRowAuthorBits: 0
267 TableStatus: Retrieved
268 Table options: readbackup
269 HashMap: DEFAULT-HASHMAP-3840-8
270 -- Attributes --
271 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
272 b Int NULL AT=FIXED ST=MEMORY
273 -- Indexes --
274 PRIMARY KEY(a) - UniqueHashIndex
275 PRIMARY(a) - OrderedIndex
276 -- AutoIncrement info
277 AutoIncrement: 1
278 insert into test.t3 (b) values (1);
279 select * from test.t3 order by a;
280 a b
281 1 1
282 After 1 insertion : 1 + 8 = 9
283 -- t3 --
284 Database: test
285 Schema: def
286 Name: t3
287 Table id: XXX
288 Version: Any
289 Fragment type: HashMapPartition
290 K Value: 6
291 Min load factor: 78
292 Max load factor: 80
293 Temporary table: no
294 Number of attributes: 2
295 Number of primary keys: 1
296 Length of frm data: XXX
297 Max Rows: 0
298 Row Checksum: 1
299 Row GCI: 1
300 SingleUserMode: 0
301 ForceVarPart: 1
302 PartitionCount: 8
303 FragmentCount: 8
304 PartitionBalance: FOR_RP_BY_LDM
305 ExtraRowGciBits: 0
306 ExtraRowAuthorBits: 0
307 TableStatus: Retrieved
308 Table options: readbackup
309 HashMap: DEFAULT-HASHMAP-3840-8
310 -- Attributes --
311 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
312 b Int NULL AT=FIXED ST=MEMORY
313 -- Indexes --
314 PRIMARY KEY(a) - UniqueHashIndex
315 PRIMARY(a) - OrderedIndex
316 -- AutoIncrement info
317 AutoIncrement: 9
318 insert into test.t3 (b) values (1), (1), (1), (1), (1), (1), (1);
319 select * from test.t3 order by a;
320 a b
321 1 1
322 2 1
323 3 1
324 4 1
325 5 1
326 6 1
327 7 1
328 8 1
329 After 8 insertions : Still 9
330 -- t3 --
331 Database: test
332 Schema: def
333 Name: t3
334 Table id: XXX
335 Version: Any
336 Fragment type: HashMapPartition
337 K Value: 6
338 Min load factor: 78
339 Max load factor: 80
340 Temporary table: no
341 Number of attributes: 2
342 Number of primary keys: 1
343 Length of frm data: XXX
344 Max Rows: 0
345 Row Checksum: 1
346 Row GCI: 1
347 SingleUserMode: 0
348 ForceVarPart: 1
349 PartitionCount: 8
350 FragmentCount: 8
351 PartitionBalance: FOR_RP_BY_LDM
352 ExtraRowGciBits: 0
353 ExtraRowAuthorBits: 0
354 TableStatus: Retrieved
355 Table options: readbackup
356 HashMap: DEFAULT-HASHMAP-3840-8
357 -- Attributes --
358 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
359 b Int NULL AT=FIXED ST=MEMORY
360 -- Indexes --
361 PRIMARY KEY(a) - UniqueHashIndex
362 PRIMARY(a) - OrderedIndex
363 -- AutoIncrement info
364 AutoIncrement: 9
365 insert into test.t3 (b) values (1);
366 select * from test.t3 order by a;
367 a b
368 1 1
369 2 1
370 3 1
371 4 1
372 5 1
373 6 1
374 7 1
375 8 1
376 9 1
377 After 9 insertions : 9 + 8 = 17
378 -- t3 --
379 Database: test
380 Schema: def
381 Name: t3
382 Table id: XXX
383 Version: Any
384 Fragment type: HashMapPartition
385 K Value: 6
386 Min load factor: 78
387 Max load factor: 80
388 Temporary table: no
389 Number of attributes: 2
390 Number of primary keys: 1
391 Length of frm data: XXX
392 Max Rows: 0
393 Row Checksum: 1
394 Row GCI: 1
395 SingleUserMode: 0
396 ForceVarPart: 1
397 PartitionCount: 8
398 FragmentCount: 8
399 PartitionBalance: FOR_RP_BY_LDM
400 ExtraRowGciBits: 0
401 ExtraRowAuthorBits: 0
402 TableStatus: Retrieved
403 Table options: readbackup
404 HashMap: DEFAULT-HASHMAP-3840-8
405 -- Attributes --
406 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
407 b Int NULL AT=FIXED ST=MEMORY
408 -- Indexes --
409 PRIMARY KEY(a) - UniqueHashIndex
410 PRIMARY(a) - OrderedIndex
411 -- AutoIncrement info
412 AutoIncrement: 17
413 drop table test.t3;
414 Show embedded-metadata behaviour
415 sys/def/SYSTAB_0 has no embedded metadata
416 -- SYSTAB_0 --
417 Version: Any
418 Fragment type: HashMapPartition
419 K Value: 6
420 Min load factor: 78
421 Max load factor: 80
422 Temporary table: no
423 Number of attributes: 2
424 Number of primary keys: 1
425 Length of frm data: XXX
426 Max Rows: 0
427 Row Checksum: 1
428 Row GCI: 1
429 SingleUserMode: 2
430 ForceVarPart: 0
431 PartitionCount: 8
432 FragmentCount: 8
433 PartitionBalance: FOR_RP_BY_LDM
434 ExtraRowGciBits: 0
435 ExtraRowAuthorBits: 0
436 TableStatus: Retrieved
437 Table options:
438 HashMap: DEFAULT-HASHMAP-3840-8
439 -- Attributes --
440 SYSKEY_0 Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
441 NEXTID Bigunsigned NOT NULL AT=FIXED ST=MEMORY
442 -- Indexes --
443 PRIMARY KEY(SYSKEY_0) - UniqueHashIndex
444 -- Embedded metadata
445 Packed len : 0
446
447 mysql/def/ndb_apply_status has embedded frm
448 include/assert_grep.inc [Version 1 embedded metadata (frm)]
449 User table has SDI with creating mysqld version
450 create table test.user_tab(a int primary key, b varchar(50) default 'Hello', c blob, d json) engine=ndb;
451 include/assert_grep.inc [SDI contains MySQL Server version]
452 drop table test.user_tab;