test/tools/catalog/exp.test006.ksh

   1 echo create table t2 and constraints with three integer fields and primary key f1;
   2 Statement Executed
   3 Statement Executed
   4 Table  created
   5 Case 1: With -D chunk  option after table creation:
   6 <Chunk information>
   7   <System Chunk >
   8         <Chunk Id> 0 </Chunk Id>
   9                 <TotalPages> 1 </TotalPages>
  10                 <ChunkName > UserChunkTableId </ChunkName>
  11                 <TotalDataNodes> 5 </TotalDataNodes>
  12                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
  13                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  14         <Chunk Id> 1 </Chunk Id>
  15                 <TotalPages> 1 </TotalPages>
  16                 <ChunkName > LockTableHashBucketId </ChunkName>
  17                 <TotalDataNodes> 1 </TotalDataNodes>
  18                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
  19                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  20         <Chunk Id> 2 </Chunk Id>
  21                 <TotalPages> 1 </TotalPages>
  22                 <ChunkName > LockTableMutexId </ChunkName>
  23                 <TotalDataNodes> 0 </TotalDataNodes>
  24                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
  25                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  26         <Chunk Id> 3 </Chunk Id>
  27                 <TotalPages> 1 </TotalPages>
  28                 <ChunkName > LockTableId </ChunkName>
  29                 <TotalDataNodes> 0 </TotalDataNodes>
  30                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
  31                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  32         <Chunk Id> 4 </Chunk Id>
  33                 <TotalPages> 1 </TotalPages>
  34                 <ChunkName > TransHasTableId </ChunkName>
  35                 <TotalDataNodes> 0 </TotalDataNodes>
  36                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
  37                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  38         <Chunk Id> 5 </Chunk Id>
  39                 <TotalPages> 1 </TotalPages>
  40                 <ChunkName > UndoLogTableId </ChunkName>
  41                 <TotalDataNodes> 0 </TotalDataNodes>
  42                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
  43                 <Allocation Type> VariableSizeAllocator </Allocation Type>
  44         <Chunk Id> 10 </Chunk Id>
  45                 <TotalPages> 1 </TotalPages>
  46                 <ChunkName > DatabaseTableId </ChunkName>
  47                 <TotalDataNodes> 0 </TotalDataNodes>
  48                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
  49                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  50         <Chunk Id> 11 </Chunk Id>
  51                 <TotalPages> 1 </TotalPages>
  52                 <ChunkName > UserTableId </ChunkName>
  53                 <TotalDataNodes> 1 </TotalDataNodes>
  54                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
  55                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  56         <Chunk Id> 12 </Chunk Id>
  57                 <TotalPages> 1 </TotalPages>
  58                 <ChunkName > TableTableId </ChunkName>
  59                 <TotalDataNodes> 1 </TotalDataNodes>
  60                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
  61                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  62         <Chunk Id> 13 </Chunk Id>
  63                 <TotalPages> 1 </TotalPages>
  64                 <ChunkName > FieldTableId </ChunkName>
  65                 <TotalDataNodes> 3 </TotalDataNodes>
  66                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
  67                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  68         <Chunk Id> 14 </Chunk Id>
  69                 <TotalPages> 1 </TotalPages>
  70                 <ChunkName > AccessTableId </ChunkName>
  71                 <TotalDataNodes> 0 </TotalDataNodes>
  72                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
  73                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  74         <Chunk Id> 15 </Chunk Id>
  75                 <TotalPages> 1 </TotalPages>
  76                 <ChunkName > IndexTableId </ChunkName>
  77                 <TotalDataNodes> 2 </TotalDataNodes>
  78                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
  79                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  80         <Chunk Id> 16 </Chunk Id>
  81                 <TotalPages> 1 </TotalPages>
  82                 <ChunkName > IndexFieldTableId </ChunkName>
  83                 <TotalDataNodes> 2 </TotalDataNodes>
  84                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
  85                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  86   </System Chunk >
  87   <User Chunk >
  88         <Chunk Id> 101 </Chunk Id>
  89                 <TotalPages> 1 </TotalPages>
  90                 <ChunkName > t2 </ChunkName>
  91                 <TotalDataNodes> 0 </TotalDataNodes>
  92                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
  93                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  94         <Chunk Id> 102 </Chunk Id>
  95                 <TotalPages> 1 </TotalPages>
  96                 <ChunkName > t2_idx1_Primary </ChunkName>
  97                 <TotalDataNodes> 1 </TotalDataNodes>
  98                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
  99                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 100         <Chunk Id> 103 </Chunk Id>
 101                 <TotalPages> 1 </TotalPages>
 102                 <ChunkName > t2_idx1_Primary </ChunkName>
 103                 <TotalDataNodes> 0 </TotalDataNodes>
 104                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 105                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 106         <Chunk Id> 104 </Chunk Id>
 107                 <TotalPages> 1 </TotalPages>
 108                 <ChunkName > t2Uniqueidx </ChunkName>
 109                 <TotalDataNodes> 1 </TotalDataNodes>
 110                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 111                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 112         <Chunk Id> 105 </Chunk Id>
 113                 <TotalPages> 1 </TotalPages>
 114                 <ChunkName > t2Uniqueidx </ChunkName>
 115                 <TotalDataNodes> 0 </TotalDataNodes>
 116                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 117                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 118   </User Chunk >
 119 </Chunk information>
 120 echo insert into t2 20 tuples;
 121 Statement Executed: Rows Affected = 1
 122 Statement Executed: Rows Affected = 1
 123 Statement Executed: Rows Affected = 1
 124 Statement Executed: Rows Affected = 1
 125 Statement Executed: Rows Affected = 1
 126 Statement Executed: Rows Affected = 1
 127 Statement Executed: Rows Affected = 1
 128 Statement Executed: Rows Affected = 1
 129 Statement Executed: Rows Affected = 1
 130 Statement Executed: Rows Affected = 1
 131 Statement Executed: Rows Affected = 1
 132 Statement Executed: Rows Affected = 1
 133 Statement Executed: Rows Affected = 1
 134 Statement Executed: Rows Affected = 1
 135 Statement Executed: Rows Affected = 1
 136 Statement Executed: Rows Affected = 1
 137 Statement Executed: Rows Affected = 1
 138 Statement Executed: Rows Affected = 1
 139 Statement Executed: Rows Affected = 1
 140 Statement Executed: Rows Affected = 1
 141 Tuples insered
 142 Case 2: With -D chunk  option after insert 20 tuples:
 143 <Chunk information>
 144   <System Chunk >
 145         <Chunk Id> 0 </Chunk Id>
 146                 <TotalPages> 1 </TotalPages>
 147                 <ChunkName > UserChunkTableId </ChunkName>
 148                 <TotalDataNodes> 5 </TotalDataNodes>
 149                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 150                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 151         <Chunk Id> 1 </Chunk Id>
 152                 <TotalPages> 1 </TotalPages>
 153                 <ChunkName > LockTableHashBucketId </ChunkName>
 154                 <TotalDataNodes> 1 </TotalDataNodes>
 155                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 156                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 157         <Chunk Id> 2 </Chunk Id>
 158                 <TotalPages> 1 </TotalPages>
 159                 <ChunkName > LockTableMutexId </ChunkName>
 160                 <TotalDataNodes> 0 </TotalDataNodes>
 161                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 162                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 163         <Chunk Id> 3 </Chunk Id>
 164                 <TotalPages> 1 </TotalPages>
 165                 <ChunkName > LockTableId </ChunkName>
 166                 <TotalDataNodes> 0 </TotalDataNodes>
 167                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 168                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 169         <Chunk Id> 4 </Chunk Id>
 170                 <TotalPages> 1 </TotalPages>
 171                 <ChunkName > TransHasTableId </ChunkName>
 172                 <TotalDataNodes> 0 </TotalDataNodes>
 173                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 174                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 175         <Chunk Id> 5 </Chunk Id>
 176                 <TotalPages> 1 </TotalPages>
 177                 <ChunkName > UndoLogTableId </ChunkName>
 178                 <TotalDataNodes> 0 </TotalDataNodes>
 179                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 180                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 181         <Chunk Id> 10 </Chunk Id>
 182                 <TotalPages> 1 </TotalPages>
 183                 <ChunkName > DatabaseTableId </ChunkName>
 184                 <TotalDataNodes> 0 </TotalDataNodes>
 185                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 186                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 187         <Chunk Id> 11 </Chunk Id>
 188                 <TotalPages> 1 </TotalPages>
 189                 <ChunkName > UserTableId </ChunkName>
 190                 <TotalDataNodes> 1 </TotalDataNodes>
 191                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 192                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 193         <Chunk Id> 12 </Chunk Id>
 194                 <TotalPages> 1 </TotalPages>
 195                 <ChunkName > TableTableId </ChunkName>
 196                 <TotalDataNodes> 1 </TotalDataNodes>
 197                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
 198                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 199         <Chunk Id> 13 </Chunk Id>
 200                 <TotalPages> 1 </TotalPages>
 201                 <ChunkName > FieldTableId </ChunkName>
 202                 <TotalDataNodes> 3 </TotalDataNodes>
 203                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 204                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 205         <Chunk Id> 14 </Chunk Id>
 206                 <TotalPages> 1 </TotalPages>
 207                 <ChunkName > AccessTableId </ChunkName>
 208                 <TotalDataNodes> 0 </TotalDataNodes>
 209                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 210                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 211         <Chunk Id> 15 </Chunk Id>
 212                 <TotalPages> 1 </TotalPages>
 213                 <ChunkName > IndexTableId </ChunkName>
 214                 <TotalDataNodes> 2 </TotalDataNodes>
 215                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 216                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 217         <Chunk Id> 16 </Chunk Id>
 218                 <TotalPages> 1 </TotalPages>
 219                 <ChunkName > IndexFieldTableId </ChunkName>
 220                 <TotalDataNodes> 2 </TotalDataNodes>
 221                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 222                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 223   </System Chunk >
 224   <User Chunk >
 225         <Chunk Id> 101 </Chunk Id>
 226                 <TotalPages> 1 </TotalPages>
 227                 <ChunkName > t2 </ChunkName>
 228                 <TotalDataNodes> 20 </TotalDataNodes>
 229                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 230                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 231         <Chunk Id> 102 </Chunk Id>
 232                 <TotalPages> 1 </TotalPages>
 233                 <ChunkName > t2_idx1_Primary </ChunkName>
 234                 <TotalDataNodes> 1 </TotalDataNodes>
 235                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 236                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 237         <Chunk Id> 103 </Chunk Id>
 238                 <TotalPages> 1 </TotalPages>
 239                 <ChunkName > t2_idx1_Primary </ChunkName>
 240                 <TotalDataNodes> 20 </TotalDataNodes>
 241                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 242                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 243         <Chunk Id> 104 </Chunk Id>
 244                 <TotalPages> 1 </TotalPages>
 245                 <ChunkName > t2Uniqueidx </ChunkName>
 246                 <TotalDataNodes> 1 </TotalDataNodes>
 247                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 248                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 249         <Chunk Id> 105 </Chunk Id>
 250                 <TotalPages> 1 </TotalPages>
 251                 <ChunkName > t2Uniqueidx </ChunkName>
 252                 <TotalDataNodes> 20 </TotalDataNodes>
 253                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 254                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 255   </User Chunk >
 256 </Chunk information>
 257 echo delete 10 tuples;
 258 Statement Executed: Rows Affected = 10
 259 10 tuples deleted
 260 Case 3: With -D chunk option after deleting 10 tuples :
 261 <Chunk information>
 262   <System Chunk >
 263         <Chunk Id> 0 </Chunk Id>
 264                 <TotalPages> 1 </TotalPages>
 265                 <ChunkName > UserChunkTableId </ChunkName>
 266                 <TotalDataNodes> 5 </TotalDataNodes>
 267                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 268                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 269         <Chunk Id> 1 </Chunk Id>
 270                 <TotalPages> 1 </TotalPages>
 271                 <ChunkName > LockTableHashBucketId </ChunkName>
 272                 <TotalDataNodes> 1 </TotalDataNodes>
 273                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 274                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 275         <Chunk Id> 2 </Chunk Id>
 276                 <TotalPages> 1 </TotalPages>
 277                 <ChunkName > LockTableMutexId </ChunkName>
 278                 <TotalDataNodes> 0 </TotalDataNodes>
 279                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 280                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 281         <Chunk Id> 3 </Chunk Id>
 282                 <TotalPages> 1 </TotalPages>
 283                 <ChunkName > LockTableId </ChunkName>
 284                 <TotalDataNodes> 0 </TotalDataNodes>
 285                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 286                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 287         <Chunk Id> 4 </Chunk Id>
 288                 <TotalPages> 1 </TotalPages>
 289                 <ChunkName > TransHasTableId </ChunkName>
 290                 <TotalDataNodes> 0 </TotalDataNodes>
 291                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 292                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 293         <Chunk Id> 5 </Chunk Id>
 294                 <TotalPages> 1 </TotalPages>
 295                 <ChunkName > UndoLogTableId </ChunkName>
 296                 <TotalDataNodes> 0 </TotalDataNodes>
 297                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 298                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 299         <Chunk Id> 10 </Chunk Id>
 300                 <TotalPages> 1 </TotalPages>
 301                 <ChunkName > DatabaseTableId </ChunkName>
 302                 <TotalDataNodes> 0 </TotalDataNodes>
 303                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 304                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 305         <Chunk Id> 11 </Chunk Id>
 306                 <TotalPages> 1 </TotalPages>
 307                 <ChunkName > UserTableId </ChunkName>
 308                 <TotalDataNodes> 1 </TotalDataNodes>
 309                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 310                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 311         <Chunk Id> 12 </Chunk Id>
 312                 <TotalPages> 1 </TotalPages>
 313                 <ChunkName > TableTableId </ChunkName>
 314                 <TotalDataNodes> 1 </TotalDataNodes>
 315                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
 316                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 317         <Chunk Id> 13 </Chunk Id>
 318                 <TotalPages> 1 </TotalPages>
 319                 <ChunkName > FieldTableId </ChunkName>
 320                 <TotalDataNodes> 3 </TotalDataNodes>
 321                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 322                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 323         <Chunk Id> 14 </Chunk Id>
 324                 <TotalPages> 1 </TotalPages>
 325                 <ChunkName > AccessTableId </ChunkName>
 326                 <TotalDataNodes> 0 </TotalDataNodes>
 327                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 328                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 329         <Chunk Id> 15 </Chunk Id>
 330                 <TotalPages> 1 </TotalPages>
 331                 <ChunkName > IndexTableId </ChunkName>
 332                 <TotalDataNodes> 2 </TotalDataNodes>
 333                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 334                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 335         <Chunk Id> 16 </Chunk Id>
 336                 <TotalPages> 1 </TotalPages>
 337                 <ChunkName > IndexFieldTableId </ChunkName>
 338                 <TotalDataNodes> 2 </TotalDataNodes>
 339                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 340                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 341   </System Chunk >
 342   <User Chunk >
 343         <Chunk Id> 101 </Chunk Id>
 344                 <TotalPages> 1 </TotalPages>
 345                 <ChunkName > t2 </ChunkName>
 346                 <TotalDataNodes> 10 </TotalDataNodes>
 347                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 348                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 349         <Chunk Id> 102 </Chunk Id>
 350                 <TotalPages> 1 </TotalPages>
 351                 <ChunkName > t2_idx1_Primary </ChunkName>
 352                 <TotalDataNodes> 1 </TotalDataNodes>
 353                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 354                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 355         <Chunk Id> 103 </Chunk Id>
 356                 <TotalPages> 1 </TotalPages>
 357                 <ChunkName > t2_idx1_Primary </ChunkName>
 358                 <TotalDataNodes> 10 </TotalDataNodes>
 359                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 360                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 361         <Chunk Id> 104 </Chunk Id>
 362                 <TotalPages> 1 </TotalPages>
 363                 <ChunkName > t2Uniqueidx </ChunkName>
 364                 <TotalDataNodes> 1 </TotalDataNodes>
 365                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 366                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 367         <Chunk Id> 105 </Chunk Id>
 368                 <TotalPages> 1 </TotalPages>
 369                 <ChunkName > t2Uniqueidx </ChunkName>
 370                 <TotalDataNodes> 10 </TotalDataNodes>
 371                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 372                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 373   </User Chunk >
 374 </Chunk information>
 375 echo drop index t2Uniqueidx;
 376 Statement Executed
 377 Index droped
 378 Case 4: With -D chunk  option after Index droped :
 379 <Chunk information>
 380   <System Chunk >
 381         <Chunk Id> 0 </Chunk Id>
 382                 <TotalPages> 1 </TotalPages>
 383                 <ChunkName > UserChunkTableId </ChunkName>
 384                 <TotalDataNodes> 3 </TotalDataNodes>
 385                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 386                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 387         <Chunk Id> 1 </Chunk Id>
 388                 <TotalPages> 1 </TotalPages>
 389                 <ChunkName > LockTableHashBucketId </ChunkName>
 390                 <TotalDataNodes> 1 </TotalDataNodes>
 391                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 392                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 393         <Chunk Id> 2 </Chunk Id>
 394                 <TotalPages> 1 </TotalPages>
 395                 <ChunkName > LockTableMutexId </ChunkName>
 396                 <TotalDataNodes> 0 </TotalDataNodes>
 397                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 398                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 399         <Chunk Id> 3 </Chunk Id>
 400                 <TotalPages> 1 </TotalPages>
 401                 <ChunkName > LockTableId </ChunkName>
 402                 <TotalDataNodes> 0 </TotalDataNodes>
 403                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 404                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 405         <Chunk Id> 4 </Chunk Id>
 406                 <TotalPages> 1 </TotalPages>
 407                 <ChunkName > TransHasTableId </ChunkName>
 408                 <TotalDataNodes> 0 </TotalDataNodes>
 409                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 410                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 411         <Chunk Id> 5 </Chunk Id>
 412                 <TotalPages> 1 </TotalPages>
 413                 <ChunkName > UndoLogTableId </ChunkName>
 414                 <TotalDataNodes> 0 </TotalDataNodes>
 415                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 416                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 417         <Chunk Id> 10 </Chunk Id>
 418                 <TotalPages> 1 </TotalPages>
 419                 <ChunkName > DatabaseTableId </ChunkName>
 420                 <TotalDataNodes> 0 </TotalDataNodes>
 421                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 422                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 423         <Chunk Id> 11 </Chunk Id>
 424                 <TotalPages> 1 </TotalPages>
 425                 <ChunkName > UserTableId </ChunkName>
 426                 <TotalDataNodes> 1 </TotalDataNodes>
 427                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 428                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 429         <Chunk Id> 12 </Chunk Id>
 430                 <TotalPages> 1 </TotalPages>
 431                 <ChunkName > TableTableId </ChunkName>
 432                 <TotalDataNodes> 1 </TotalDataNodes>
 433                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
 434                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 435         <Chunk Id> 13 </Chunk Id>
 436                 <TotalPages> 1 </TotalPages>
 437                 <ChunkName > FieldTableId </ChunkName>
 438                 <TotalDataNodes> 3 </TotalDataNodes>
 439                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 440                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 441         <Chunk Id> 14 </Chunk Id>
 442                 <TotalPages> 1 </TotalPages>
 443                 <ChunkName > AccessTableId </ChunkName>
 444                 <TotalDataNodes> 0 </TotalDataNodes>
 445                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 446                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 447         <Chunk Id> 15 </Chunk Id>
 448                 <TotalPages> 1 </TotalPages>
 449                 <ChunkName > IndexTableId </ChunkName>
 450                 <TotalDataNodes> 1 </TotalDataNodes>
 451                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 452                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 453         <Chunk Id> 16 </Chunk Id>
 454                 <TotalPages> 1 </TotalPages>
 455                 <ChunkName > IndexFieldTableId </ChunkName>
 456                 <TotalDataNodes> 1 </TotalDataNodes>
 457                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 458                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 459   </System Chunk >
 460   <User Chunk >
 461         <Chunk Id> 101 </Chunk Id>
 462                 <TotalPages> 1 </TotalPages>
 463                 <ChunkName > t2 </ChunkName>
 464                 <TotalDataNodes> 10 </TotalDataNodes>
 465                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 466                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 467         <Chunk Id> 102 </Chunk Id>
 468                 <TotalPages> 1 </TotalPages>
 469                 <ChunkName > t2_idx1_Primary </ChunkName>
 470                 <TotalDataNodes> 1 </TotalDataNodes>
 471                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 472                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 473         <Chunk Id> 103 </Chunk Id>
 474                 <TotalPages> 1 </TotalPages>
 475                 <ChunkName > t2_idx1_Primary </ChunkName>
 476                 <TotalDataNodes> 10 </TotalDataNodes>
 477                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 478                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 479   </User Chunk >
 480 </Chunk information>
 481 echo  drop table t2;
 482 Statement Executed
 483 t2 table droped with index
 484 Case 5: With -D chunk  option after drop t2 :
 485 <Chunk information>
 486   <System Chunk >
 487         <Chunk Id> 0 </Chunk Id>
 488                 <TotalPages> 1 </TotalPages>
 489                 <ChunkName > UserChunkTableId </ChunkName>
 490                 <TotalDataNodes> 0 </TotalDataNodes>
 491                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 492                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 493         <Chunk Id> 1 </Chunk Id>
 494                 <TotalPages> 1 </TotalPages>
 495                 <ChunkName > LockTableHashBucketId </ChunkName>
 496                 <TotalDataNodes> 1 </TotalDataNodes>
 497                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 498                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 499         <Chunk Id> 2 </Chunk Id>
 500                 <TotalPages> 1 </TotalPages>
 501                 <ChunkName > LockTableMutexId </ChunkName>
 502                 <TotalDataNodes> 0 </TotalDataNodes>
 503                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 504                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 505         <Chunk Id> 3 </Chunk Id>
 506                 <TotalPages> 1 </TotalPages>
 507                 <ChunkName > LockTableId </ChunkName>
 508                 <TotalDataNodes> 0 </TotalDataNodes>
 509                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 510                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 511         <Chunk Id> 4 </Chunk Id>
 512                 <TotalPages> 1 </TotalPages>
 513                 <ChunkName > TransHasTableId </ChunkName>
 514                 <TotalDataNodes> 0 </TotalDataNodes>
 515                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 516                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 517         <Chunk Id> 5 </Chunk Id>
 518                 <TotalPages> 1 </TotalPages>
 519                 <ChunkName > UndoLogTableId </ChunkName>
 520                 <TotalDataNodes> 0 </TotalDataNodes>
 521                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 522                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 523         <Chunk Id> 10 </Chunk Id>
 524                 <TotalPages> 1 </TotalPages>
 525                 <ChunkName > DatabaseTableId </ChunkName>
 526                 <TotalDataNodes> 0 </TotalDataNodes>
 527                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 528                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 529         <Chunk Id> 11 </Chunk Id>
 530                 <TotalPages> 1 </TotalPages>
 531                 <ChunkName > UserTableId </ChunkName>
 532                 <TotalDataNodes> 1 </TotalDataNodes>
 533                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 534                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 535         <Chunk Id> 12 </Chunk Id>
 536                 <TotalPages> 1 </TotalPages>
 537                 <ChunkName > TableTableId </ChunkName>
 538                 <TotalDataNodes> 0 </TotalDataNodes>
 539                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
 540                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 541         <Chunk Id> 13 </Chunk Id>
 542                 <TotalPages> 1 </TotalPages>
 543                 <ChunkName > FieldTableId </ChunkName>
 544                 <TotalDataNodes> 0 </TotalDataNodes>
 545                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 546                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 547         <Chunk Id> 14 </Chunk Id>
 548                 <TotalPages> 1 </TotalPages>
 549                 <ChunkName > AccessTableId </ChunkName>
 550                 <TotalDataNodes> 0 </TotalDataNodes>
 551                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 552                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 553         <Chunk Id> 15 </Chunk Id>
 554                 <TotalPages> 1 </TotalPages>
 555                 <ChunkName > IndexTableId </ChunkName>
 556                 <TotalDataNodes> 0 </TotalDataNodes>
 557                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 558                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 559         <Chunk Id> 16 </Chunk Id>
 560                 <TotalPages> 1 </TotalPages>
 561                 <ChunkName > IndexFieldTableId </ChunkName>
 562                 <TotalDataNodes> 0 </TotalDataNodes>
 563                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 564                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 565   </System Chunk >
 566   <User Chunk >
 567   </User Chunk >
 568 </Chunk information>