Debian Codegraph @

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

raw
1 # bug#14695968
2 "ndb_desc -pb with tinyblob column"
3 CREATE TABLE test.t1 (a int primary key, b tinyblob)engine=ndbcluster;
4 -- t1 --
5 Version: Any
6 Fragment type: HashMapPartition
7 K Value: 6
8 Min load factor: 78
9 Max load factor: 80
10 Temporary table: no
11 Number of attributes: 2
12 Number of primary keys: 1
13 Length of frm data: XXX
14 Max Rows: 0
15 Row Checksum: 1
16 Row GCI: 1
17 SingleUserMode: 0
18 ForceVarPart: 1
19 PartitionCount: 8
20 FragmentCount: 8
21 PartitionBalance: FOR_RP_BY_LDM
22 ExtraRowGciBits: 0
23 ExtraRowAuthorBits: 0
24 TableStatus: Retrieved
25 Table options:
26 HashMap: DEFAULT-HASHMAP-3840-8
27 -- Attributes --
28 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
29 b Blob(256,0,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=<none>
30 -- Indexes --
31 PRIMARY KEY(a) - UniqueHashIndex
32 PRIMARY(a) - OrderedIndex
33 -- Per partition info for t1 --
34 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
35
36
37 "ndb_desc -pb with all types of blob and text columns"
38 CREATE TABLE test.t2 (a int primary key, b tinyblob, c mediumblob,
39 d blob, e longblob,f tinytext, g text, h mediumtext, i longtext)
40 engine=ndbcluster;
41 -- t2 --
42 Version: Any
43 Fragment type: HashMapPartition
44 K Value: 6
45 Min load factor: 78
46 Max load factor: 80
47 Temporary table: no
48 Number of attributes: 9
49 Number of primary keys: 1
50 Length of frm data: XXX
51 Max Rows: 0
52 Row Checksum: 1
53 Row GCI: 1
54 SingleUserMode: 0
55 ForceVarPart: 1
56 PartitionCount: 8
57 FragmentCount: 8
58 PartitionBalance: FOR_RP_BY_LDM
59 ExtraRowGciBits: 0
60 ExtraRowAuthorBits: 0
61 TableStatus: Retrieved
62 Table options:
63 HashMap: DEFAULT-HASHMAP-3840-8
64 -- Attributes --
65 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
66 b Blob(256,0,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=<none>
67 c Blob(256,4000,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_XX_2
68 d Blob(256,2000,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_XX_3
69 e Blob(256,13948,0) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_XX_4
70 f Text(256,0,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=<none>
71 g Text(256,2000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_XX_6
72 h Text(256,4000,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_XX_7
73 i Text(256,13948,0;utf8mb4_0900_ai_ci) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_XX_8
74 -- Indexes --
75 PRIMARY KEY(a) - UniqueHashIndex
76 PRIMARY(a) - OrderedIndex
77 -- Per partition info for t2 --
78 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
79
80
81 -- NDB$BLOB_XX_2 --
82 Version: Any
83 Fragment type: HashMapPartition
84 K Value: 6
85 Min load factor: 78
86 Max load factor: 80
87 Temporary table: no
88 Number of attributes: 4
89 Number of primary keys: 2
90 Length of frm data: XXX
91 Max Rows: 0
92 Row Checksum: 1
93 Row GCI: 1
94 SingleUserMode: 0
95 ForceVarPart: 0
96 PartitionCount: 8
97 FragmentCount: 8
98 PartitionBalance: FOR_RP_BY_LDM
99 ExtraRowGciBits: 0
100 ExtraRowAuthorBits: 0
101 TableStatus: Retrieved
102 Table options:
103 HashMap: DEFAULT-HASHMAP-3840-8
104 -- Attributes --
105 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
106 NDB$PART Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
107 NDB$PKID Unsigned NOT NULL AT=FIXED ST=MEMORY
108 NDB$DATA Longvarbinary(4000) NOT NULL AT=MEDIUM_VAR ST=MEMORY
109 -- Indexes --
110 PRIMARY KEY(a, NDB$PART) - UniqueHashIndex
111 -- Per partition info for NDB$BLOB_XX_2 --
112 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
113
114
115 -- NDB$BLOB_XX_3 --
116 Version: Any
117 Fragment type: HashMapPartition
118 K Value: 6
119 Min load factor: 78
120 Max load factor: 80
121 Temporary table: no
122 Number of attributes: 4
123 Number of primary keys: 2
124 Length of frm data: XXX
125 Max Rows: 0
126 Row Checksum: 1
127 Row GCI: 1
128 SingleUserMode: 0
129 ForceVarPart: 0
130 PartitionCount: 8
131 FragmentCount: 8
132 PartitionBalance: FOR_RP_BY_LDM
133 ExtraRowGciBits: 0
134 ExtraRowAuthorBits: 0
135 TableStatus: Retrieved
136 Table options:
137 HashMap: DEFAULT-HASHMAP-3840-8
138 -- Attributes --
139 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
140 NDB$PART Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
141 NDB$PKID Unsigned NOT NULL AT=FIXED ST=MEMORY
142 NDB$DATA Longvarbinary(2000) NOT NULL AT=MEDIUM_VAR ST=MEMORY
143 -- Indexes --
144 PRIMARY KEY(a, NDB$PART) - UniqueHashIndex
145 -- Per partition info for NDB$BLOB_XX_3 --
146 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
147
148
149 -- NDB$BLOB_XX_4 --
150 Version: Any
151 Fragment type: HashMapPartition
152 K Value: 6
153 Min load factor: 78
154 Max load factor: 80
155 Temporary table: no
156 Number of attributes: 4
157 Number of primary keys: 2
158 Length of frm data: XXX
159 Max Rows: 0
160 Row Checksum: 1
161 Row GCI: 1
162 SingleUserMode: 0
163 ForceVarPart: 0
164 PartitionCount: 8
165 FragmentCount: 8
166 PartitionBalance: FOR_RP_BY_LDM
167 ExtraRowGciBits: 0
168 ExtraRowAuthorBits: 0
169 TableStatus: Retrieved
170 Table options:
171 HashMap: DEFAULT-HASHMAP-3840-8
172 -- Attributes --
173 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
174 NDB$PART Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
175 NDB$PKID Unsigned NOT NULL AT=FIXED ST=MEMORY
176 NDB$DATA Longvarbinary(13948) NOT NULL AT=MEDIUM_VAR ST=MEMORY
177 -- Indexes --
178 PRIMARY KEY(a, NDB$PART) - UniqueHashIndex
179 -- Per partition info for NDB$BLOB_XX_4 --
180 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
181
182
183
184 -- NDB$BLOB_XX_6 --
185 Version: Any
186 Fragment type: HashMapPartition
187 K Value: 6
188 Min load factor: 78
189 Max load factor: 80
190 Temporary table: no
191 Number of attributes: 4
192 Number of primary keys: 2
193 Length of frm data: XXX
194 Max Rows: 0
195 Row Checksum: 1
196 Row GCI: 1
197 SingleUserMode: 0
198 ForceVarPart: 0
199 PartitionCount: 8
200 FragmentCount: 8
201 PartitionBalance: FOR_RP_BY_LDM
202 ExtraRowGciBits: 0
203 ExtraRowAuthorBits: 0
204 TableStatus: Retrieved
205 Table options:
206 HashMap: DEFAULT-HASHMAP-3840-8
207 -- Attributes --
208 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
209 NDB$PART Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
210 NDB$PKID Unsigned NOT NULL AT=FIXED ST=MEMORY
211 NDB$DATA Longvarchar(2000;binary) NOT NULL AT=MEDIUM_VAR ST=MEMORY
212 -- Indexes --
213 PRIMARY KEY(a, NDB$PART) - UniqueHashIndex
214 -- Per partition info for NDB$BLOB_XX_6 --
215 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
216
217
218 -- NDB$BLOB_XX_7 --
219 Version: Any
220 Fragment type: HashMapPartition
221 K Value: 6
222 Min load factor: 78
223 Max load factor: 80
224 Temporary table: no
225 Number of attributes: 4
226 Number of primary keys: 2
227 Length of frm data: XXX
228 Max Rows: 0
229 Row Checksum: 1
230 Row GCI: 1
231 SingleUserMode: 0
232 ForceVarPart: 0
233 PartitionCount: 8
234 FragmentCount: 8
235 PartitionBalance: FOR_RP_BY_LDM
236 ExtraRowGciBits: 0
237 ExtraRowAuthorBits: 0
238 TableStatus: Retrieved
239 Table options:
240 HashMap: DEFAULT-HASHMAP-3840-8
241 -- Attributes --
242 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
243 NDB$PART Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
244 NDB$PKID Unsigned NOT NULL AT=FIXED ST=MEMORY
245 NDB$DATA Longvarchar(4000;binary) NOT NULL AT=MEDIUM_VAR ST=MEMORY
246 -- Indexes --
247 PRIMARY KEY(a, NDB$PART) - UniqueHashIndex
248 -- Per partition info for NDB$BLOB_XX_7 --
249 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
250
251
252 -- NDB$BLOB_XX_8 --
253 Version: Any
254 Fragment type: HashMapPartition
255 K Value: 6
256 Min load factor: 78
257 Max load factor: 80
258 Temporary table: no
259 Number of attributes: 4
260 Number of primary keys: 2
261 Length of frm data: XXX
262 Max Rows: 0
263 Row Checksum: 1
264 Row GCI: 1
265 SingleUserMode: 0
266 ForceVarPart: 0
267 PartitionCount: 8
268 FragmentCount: 8
269 PartitionBalance: FOR_RP_BY_LDM
270 ExtraRowGciBits: 0
271 ExtraRowAuthorBits: 0
272 TableStatus: Retrieved
273 Table options:
274 HashMap: DEFAULT-HASHMAP-3840-8
275 -- Attributes --
276 a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
277 NDB$PART Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
278 NDB$PKID Unsigned NOT NULL AT=FIXED ST=MEMORY
279 NDB$DATA Longvarchar(13948;binary) NOT NULL AT=MEDIUM_VAR ST=MEMORY
280 -- Indexes --
281 PRIMARY KEY(a, NDB$PART) - UniqueHashIndex
282 -- Per partition info for NDB$BLOB_XX_8 --
283 Partition Row count Commit count Frag fixed memory Frag varsized memory Extent_space Free extent_space
284
285
286 DROP TABLE test.t1;
287 DROP TABLE test.t2;