1 Case
1: With
-D chunk option with empty database
4 <Chunk Id
> 0 </Chunk Id
>
5 <TotalPages
> 1 </TotalPages
>
6 <ChunkName
> UserChunkTableId
</ChunkName
>
7 <TotalDataNodes
> 0 </TotalDataNodes
>
8 <SizeOfDataNodes
> 112 </SizeOfDataNodes
>
9 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
10 <Chunk Id
> 1 </Chunk Id
>
11 <TotalPages
> 1 </TotalPages
>
12 <ChunkName
> LockTableHashBucketId
</ChunkName
>
13 <TotalDataNodes
> 1 </TotalDataNodes
>
14 <SizeOfDataNodes
> 57348 </SizeOfDataNodes
>
15 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
16 <Chunk Id
> 2 </Chunk Id
>
17 <TotalPages
> 1 </TotalPages
>
18 <ChunkName
> LockTableMutexId
</ChunkName
>
19 <TotalDataNodes
> 0 </TotalDataNodes
>
20 <SizeOfDataNodes
> 49156 </SizeOfDataNodes
>
21 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
22 <Chunk Id
> 3 </Chunk Id
>
23 <TotalPages
> 1 </TotalPages
>
24 <ChunkName
> LockTableId
</ChunkName
>
25 <TotalDataNodes
> 0 </TotalDataNodes
>
26 <SizeOfDataNodes
> 24 </SizeOfDataNodes
>
27 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
28 <Chunk Id
> 4 </Chunk Id
>
29 <TotalPages
> 1 </TotalPages
>
30 <ChunkName
> TransHasTableId
</ChunkName
>
31 <TotalDataNodes
> 0 </TotalDataNodes
>
32 <SizeOfDataNodes
> 12 </SizeOfDataNodes
>
33 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
34 <Chunk Id
> 5 </Chunk Id
>
35 <TotalPages
> 1 </TotalPages
>
36 <ChunkName
> UndoLogTableId
</ChunkName
>
37 <TotalDataNodes
> 0 </TotalDataNodes
>
38 <SizeOfDataNodes
> 0 </SizeOfDataNodes
>
39 <Allocation Type
> VariableSizeAllocator
</Allocation Type
>
40 <Chunk Id
> 10 </Chunk Id
>
41 <TotalPages
> 1 </TotalPages
>
42 <ChunkName
> DatabaseTableId
</ChunkName
>
43 <TotalDataNodes
> 0 </TotalDataNodes
>
44 <SizeOfDataNodes
> 84 </SizeOfDataNodes
>
45 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
46 <Chunk Id
> 11 </Chunk Id
>
47 <TotalPages
> 1 </TotalPages
>
48 <ChunkName
> UserTableId
</ChunkName
>
49 <TotalDataNodes
> 2 </TotalDataNodes
>
50 <SizeOfDataNodes
> 132 </SizeOfDataNodes
>
51 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
52 <Chunk Id
> 12 </Chunk Id
>
53 <TotalPages
> 1 </TotalPages
>
54 <ChunkName
> TableTableId
</ChunkName
>
55 <TotalDataNodes
> 0 </TotalDataNodes
>
56 <SizeOfDataNodes
> 92 </SizeOfDataNodes
>
57 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
58 <Chunk Id
> 13 </Chunk Id
>
59 <TotalPages
> 1 </TotalPages
>
60 <ChunkName
> FieldTableId
</ChunkName
>
61 <TotalDataNodes
> 0 </TotalDataNodes
>
62 <SizeOfDataNodes
> 144 </SizeOfDataNodes
>
63 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
64 <Chunk Id
> 14 </Chunk Id
>
65 <TotalPages
> 1 </TotalPages
>
66 <ChunkName
> AccessTableId
</ChunkName
>
67 <TotalDataNodes
> 0 </TotalDataNodes
>
68 <SizeOfDataNodes
> 132 </SizeOfDataNodes
>
69 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
70 <Chunk Id
> 15 </Chunk Id
>
71 <TotalPages
> 1 </TotalPages
>
72 <ChunkName
> IndexTableId
</ChunkName
>
73 <TotalDataNodes
> 0 </TotalDataNodes
>
74 <SizeOfDataNodes
> 104 </SizeOfDataNodes
>
75 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
76 <Chunk Id
> 16 </Chunk Id
>
77 <TotalPages
> 1 </TotalPages
>
78 <ChunkName
> IndexFieldTableId
</ChunkName
>
79 <TotalDataNodes
> 0 </TotalDataNodes
>
80 <SizeOfDataNodes
> 20 </SizeOfDataNodes
>
81 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
82 <Chunk Id
> 17 </Chunk Id
>
83 <TotalPages
> 1 </TotalPages
>
84 <ChunkName
> ForeignKeyTableId
</ChunkName
>
85 <TotalDataNodes
> 0 </TotalDataNodes
>
86 <SizeOfDataNodes
> 76 </SizeOfDataNodes
>
87 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
88 <Chunk Id
> 18 </Chunk Id
>
89 <TotalPages
> 1 </TotalPages
>
90 <ChunkName
> ForeignKeyFieldTableId
</ChunkName
>
91 <TotalDataNodes
> 0 </TotalDataNodes
>
92 <SizeOfDataNodes
> 16 </SizeOfDataNodes
>
93 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
98 echo create table and constraints with integer fields
;
100 Statement Executed
: Rows Affected
= 1
101 Statement Executed
: Rows Affected
= 1
102 Statement Executed
: Rows Affected
= 1
103 Statement Executed
: Rows Affected
= 1
104 Statement Executed
: Rows Affected
= 1
105 Statement Executed
: Rows Affected
= 1
106 Statement Executed
: Rows Affected
= 1
107 Statement Executed
: Rows Affected
= 1
108 Statement Executed
: Rows Affected
= 1
109 Statement Executed
: Rows Affected
= 1
110 Case
2: With
-D chunk option after table creation
:
113 <Chunk Id
> 0 </Chunk Id
>
114 <TotalPages
> 1 </TotalPages
>
115 <ChunkName
> UserChunkTableId
</ChunkName
>
116 <TotalDataNodes
> 1 </TotalDataNodes
>
117 <SizeOfDataNodes
> 112 </SizeOfDataNodes
>
118 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
119 <Chunk Id
> 1 </Chunk Id
>
120 <TotalPages
> 1 </TotalPages
>
121 <ChunkName
> LockTableHashBucketId
</ChunkName
>
122 <TotalDataNodes
> 1 </TotalDataNodes
>
123 <SizeOfDataNodes
> 57348 </SizeOfDataNodes
>
124 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
125 <Chunk Id
> 2 </Chunk Id
>
126 <TotalPages
> 1 </TotalPages
>
127 <ChunkName
> LockTableMutexId
</ChunkName
>
128 <TotalDataNodes
> 0 </TotalDataNodes
>
129 <SizeOfDataNodes
> 49156 </SizeOfDataNodes
>
130 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
131 <Chunk Id
> 3 </Chunk Id
>
132 <TotalPages
> 1 </TotalPages
>
133 <ChunkName
> LockTableId
</ChunkName
>
134 <TotalDataNodes
> 0 </TotalDataNodes
>
135 <SizeOfDataNodes
> 24 </SizeOfDataNodes
>
136 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
137 <Chunk Id
> 4 </Chunk Id
>
138 <TotalPages
> 1 </TotalPages
>
139 <ChunkName
> TransHasTableId
</ChunkName
>
140 <TotalDataNodes
> 0 </TotalDataNodes
>
141 <SizeOfDataNodes
> 12 </SizeOfDataNodes
>
142 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
143 <Chunk Id
> 5 </Chunk Id
>
144 <TotalPages
> 1 </TotalPages
>
145 <ChunkName
> UndoLogTableId
</ChunkName
>
146 <TotalDataNodes
> 0 </TotalDataNodes
>
147 <SizeOfDataNodes
> 0 </SizeOfDataNodes
>
148 <Allocation Type
> VariableSizeAllocator
</Allocation Type
>
149 <Chunk Id
> 10 </Chunk Id
>
150 <TotalPages
> 1 </TotalPages
>
151 <ChunkName
> DatabaseTableId
</ChunkName
>
152 <TotalDataNodes
> 0 </TotalDataNodes
>
153 <SizeOfDataNodes
> 84 </SizeOfDataNodes
>
154 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
155 <Chunk Id
> 11 </Chunk Id
>
156 <TotalPages
> 1 </TotalPages
>
157 <ChunkName
> UserTableId
</ChunkName
>
158 <TotalDataNodes
> 2 </TotalDataNodes
>
159 <SizeOfDataNodes
> 132 </SizeOfDataNodes
>
160 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
161 <Chunk Id
> 12 </Chunk Id
>
162 <TotalPages
> 1 </TotalPages
>
163 <ChunkName
> TableTableId
</ChunkName
>
164 <TotalDataNodes
> 1 </TotalDataNodes
>
165 <SizeOfDataNodes
> 92 </SizeOfDataNodes
>
166 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
167 <Chunk Id
> 13 </Chunk Id
>
168 <TotalPages
> 1 </TotalPages
>
169 <ChunkName
> FieldTableId
</ChunkName
>
170 <TotalDataNodes
> 2 </TotalDataNodes
>
171 <SizeOfDataNodes
> 144 </SizeOfDataNodes
>
172 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
173 <Chunk Id
> 14 </Chunk Id
>
174 <TotalPages
> 1 </TotalPages
>
175 <ChunkName
> AccessTableId
</ChunkName
>
176 <TotalDataNodes
> 0 </TotalDataNodes
>
177 <SizeOfDataNodes
> 132 </SizeOfDataNodes
>
178 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
179 <Chunk Id
> 15 </Chunk Id
>
180 <TotalPages
> 1 </TotalPages
>
181 <ChunkName
> IndexTableId
</ChunkName
>
182 <TotalDataNodes
> 0 </TotalDataNodes
>
183 <SizeOfDataNodes
> 104 </SizeOfDataNodes
>
184 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
185 <Chunk Id
> 16 </Chunk Id
>
186 <TotalPages
> 1 </TotalPages
>
187 <ChunkName
> IndexFieldTableId
</ChunkName
>
188 <TotalDataNodes
> 0 </TotalDataNodes
>
189 <SizeOfDataNodes
> 20 </SizeOfDataNodes
>
190 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
191 <Chunk Id
> 17 </Chunk Id
>
192 <TotalPages
> 1 </TotalPages
>
193 <ChunkName
> ForeignKeyTableId
</ChunkName
>
194 <TotalDataNodes
> 0 </TotalDataNodes
>
195 <SizeOfDataNodes
> 76 </SizeOfDataNodes
>
196 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
197 <Chunk Id
> 18 </Chunk Id
>
198 <TotalPages
> 1 </TotalPages
>
199 <ChunkName
> ForeignKeyFieldTableId
</ChunkName
>
200 <TotalDataNodes
> 0 </TotalDataNodes
>
201 <SizeOfDataNodes
> 16 </SizeOfDataNodes
>
202 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
205 <Chunk Id
> 101 </Chunk Id
>
206 <TotalPages
> 1 </TotalPages
>
207 <ChunkName
> t1
</ChunkName
>
208 <TotalDataNodes
> 10 </TotalDataNodes
>
209 <SizeOfDataNodes
> 16 </SizeOfDataNodes
>
210 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
216 Case
3: With
-D chunk option after drop t1
:
219 <Chunk Id
> 0 </Chunk Id
>
220 <TotalPages
> 1 </TotalPages
>
221 <ChunkName
> UserChunkTableId
</ChunkName
>
222 <TotalDataNodes
> 0 </TotalDataNodes
>
223 <SizeOfDataNodes
> 112 </SizeOfDataNodes
>
224 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
225 <Chunk Id
> 1 </Chunk Id
>
226 <TotalPages
> 1 </TotalPages
>
227 <ChunkName
> LockTableHashBucketId
</ChunkName
>
228 <TotalDataNodes
> 1 </TotalDataNodes
>
229 <SizeOfDataNodes
> 57348 </SizeOfDataNodes
>
230 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
231 <Chunk Id
> 2 </Chunk Id
>
232 <TotalPages
> 1 </TotalPages
>
233 <ChunkName
> LockTableMutexId
</ChunkName
>
234 <TotalDataNodes
> 0 </TotalDataNodes
>
235 <SizeOfDataNodes
> 49156 </SizeOfDataNodes
>
236 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
237 <Chunk Id
> 3 </Chunk Id
>
238 <TotalPages
> 1 </TotalPages
>
239 <ChunkName
> LockTableId
</ChunkName
>
240 <TotalDataNodes
> 0 </TotalDataNodes
>
241 <SizeOfDataNodes
> 24 </SizeOfDataNodes
>
242 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
243 <Chunk Id
> 4 </Chunk Id
>
244 <TotalPages
> 1 </TotalPages
>
245 <ChunkName
> TransHasTableId
</ChunkName
>
246 <TotalDataNodes
> 0 </TotalDataNodes
>
247 <SizeOfDataNodes
> 12 </SizeOfDataNodes
>
248 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
249 <Chunk Id
> 5 </Chunk Id
>
250 <TotalPages
> 1 </TotalPages
>
251 <ChunkName
> UndoLogTableId
</ChunkName
>
252 <TotalDataNodes
> 0 </TotalDataNodes
>
253 <SizeOfDataNodes
> 0 </SizeOfDataNodes
>
254 <Allocation Type
> VariableSizeAllocator
</Allocation Type
>
255 <Chunk Id
> 10 </Chunk Id
>
256 <TotalPages
> 1 </TotalPages
>
257 <ChunkName
> DatabaseTableId
</ChunkName
>
258 <TotalDataNodes
> 0 </TotalDataNodes
>
259 <SizeOfDataNodes
> 84 </SizeOfDataNodes
>
260 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
261 <Chunk Id
> 11 </Chunk Id
>
262 <TotalPages
> 1 </TotalPages
>
263 <ChunkName
> UserTableId
</ChunkName
>
264 <TotalDataNodes
> 2 </TotalDataNodes
>
265 <SizeOfDataNodes
> 132 </SizeOfDataNodes
>
266 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
267 <Chunk Id
> 12 </Chunk Id
>
268 <TotalPages
> 1 </TotalPages
>
269 <ChunkName
> TableTableId
</ChunkName
>
270 <TotalDataNodes
> 0 </TotalDataNodes
>
271 <SizeOfDataNodes
> 92 </SizeOfDataNodes
>
272 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
273 <Chunk Id
> 13 </Chunk Id
>
274 <TotalPages
> 1 </TotalPages
>
275 <ChunkName
> FieldTableId
</ChunkName
>
276 <TotalDataNodes
> 0 </TotalDataNodes
>
277 <SizeOfDataNodes
> 144 </SizeOfDataNodes
>
278 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
279 <Chunk Id
> 14 </Chunk Id
>
280 <TotalPages
> 1 </TotalPages
>
281 <ChunkName
> AccessTableId
</ChunkName
>
282 <TotalDataNodes
> 0 </TotalDataNodes
>
283 <SizeOfDataNodes
> 132 </SizeOfDataNodes
>
284 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
285 <Chunk Id
> 15 </Chunk Id
>
286 <TotalPages
> 1 </TotalPages
>
287 <ChunkName
> IndexTableId
</ChunkName
>
288 <TotalDataNodes
> 0 </TotalDataNodes
>
289 <SizeOfDataNodes
> 104 </SizeOfDataNodes
>
290 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
291 <Chunk Id
> 16 </Chunk Id
>
292 <TotalPages
> 1 </TotalPages
>
293 <ChunkName
> IndexFieldTableId
</ChunkName
>
294 <TotalDataNodes
> 0 </TotalDataNodes
>
295 <SizeOfDataNodes
> 20 </SizeOfDataNodes
>
296 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
297 <Chunk Id
> 17 </Chunk Id
>
298 <TotalPages
> 1 </TotalPages
>
299 <ChunkName
> ForeignKeyTableId
</ChunkName
>
300 <TotalDataNodes
> 0 </TotalDataNodes
>
301 <SizeOfDataNodes
> 76 </SizeOfDataNodes
>
302 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>
303 <Chunk Id
> 18 </Chunk Id
>
304 <TotalPages
> 1 </TotalPages
>
305 <ChunkName
> ForeignKeyFieldTableId
</ChunkName
>
306 <TotalDataNodes
> 0 </TotalDataNodes
>
307 <SizeOfDataNodes
> 16 </SizeOfDataNodes
>
308 <Allocation Type
> FixedSizeAllocator
</Allocation Type
>