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> 24 </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> 2 </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> 92 </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> 144 </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         <Chunk Id> 17 </Chunk Id>
  87                 <TotalPages> 1 </TotalPages>
  88                 <ChunkName > ForeignKeyTableId </ChunkName>
  89                 <TotalDataNodes> 0 </TotalDataNodes>
  90                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
  91                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  92         <Chunk Id> 18 </Chunk Id>
  93                 <TotalPages> 1 </TotalPages>
  94                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
  95                 <TotalDataNodes> 0 </TotalDataNodes>
  96                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
  97                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  98   </System Chunk >
  99   <User Chunk >
 100         <Chunk Id> 101 </Chunk Id>
 101                 <TotalPages> 1 </TotalPages>
 102                 <ChunkName > t2 </ChunkName>
 103                 <TotalDataNodes> 0 </TotalDataNodes>
 104                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 105                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 106         <Chunk Id> 102 </Chunk Id>
 107                 <TotalPages> 1 </TotalPages>
 108                 <ChunkName > t2_idx1_Primary </ChunkName>
 109                 <TotalDataNodes> 1 </TotalDataNodes>
 110                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 111                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 112         <Chunk Id> 103 </Chunk Id>
 113                 <TotalPages> 1 </TotalPages>
 114                 <ChunkName > t2_idx1_Primary </ChunkName>
 115                 <TotalDataNodes> 0 </TotalDataNodes>
 116                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 117                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 118         <Chunk Id> 104 </Chunk Id>
 119                 <TotalPages> 1 </TotalPages>
 120                 <ChunkName > t2Uniqueidx </ChunkName>
 121                 <TotalDataNodes> 1 </TotalDataNodes>
 122                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 123                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 124         <Chunk Id> 105 </Chunk Id>
 125                 <TotalPages> 1 </TotalPages>
 126                 <ChunkName > t2Uniqueidx </ChunkName>
 127                 <TotalDataNodes> 0 </TotalDataNodes>
 128                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 129                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 130   </User Chunk >
 131 </Chunk information>
 132 echo insert into t2 20 tuples;
 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 Statement Executed: Rows Affected = 1
 142 Statement Executed: Rows Affected = 1
 143 Statement Executed: Rows Affected = 1
 144 Statement Executed: Rows Affected = 1
 145 Statement Executed: Rows Affected = 1
 146 Statement Executed: Rows Affected = 1
 147 Statement Executed: Rows Affected = 1
 148 Statement Executed: Rows Affected = 1
 149 Statement Executed: Rows Affected = 1
 150 Statement Executed: Rows Affected = 1
 151 Statement Executed: Rows Affected = 1
 152 Statement Executed: Rows Affected = 1
 153 Tuples insered
 154 Case 2: With -D chunk  option after insert 20 tuples:
 155 <Chunk information>
 156   <System Chunk >
 157         <Chunk Id> 0 </Chunk Id>
 158                 <TotalPages> 1 </TotalPages>
 159                 <ChunkName > UserChunkTableId </ChunkName>
 160                 <TotalDataNodes> 5 </TotalDataNodes>
 161                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 162                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 163         <Chunk Id> 1 </Chunk Id>
 164                 <TotalPages> 1 </TotalPages>
 165                 <ChunkName > LockTableHashBucketId </ChunkName>
 166                 <TotalDataNodes> 1 </TotalDataNodes>
 167                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 168                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 169         <Chunk Id> 2 </Chunk Id>
 170                 <TotalPages> 1 </TotalPages>
 171                 <ChunkName > LockTableMutexId </ChunkName>
 172                 <TotalDataNodes> 0 </TotalDataNodes>
 173                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 174                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 175         <Chunk Id> 3 </Chunk Id>
 176                 <TotalPages> 1 </TotalPages>
 177                 <ChunkName > LockTableId </ChunkName>
 178                 <TotalDataNodes> 0 </TotalDataNodes>
 179                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
 180                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 181         <Chunk Id> 4 </Chunk Id>
 182                 <TotalPages> 1 </TotalPages>
 183                 <ChunkName > TransHasTableId </ChunkName>
 184                 <TotalDataNodes> 0 </TotalDataNodes>
 185                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 186                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 187         <Chunk Id> 5 </Chunk Id>
 188                 <TotalPages> 1 </TotalPages>
 189                 <ChunkName > UndoLogTableId </ChunkName>
 190                 <TotalDataNodes> 0 </TotalDataNodes>
 191                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 192                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 193         <Chunk Id> 10 </Chunk Id>
 194                 <TotalPages> 1 </TotalPages>
 195                 <ChunkName > DatabaseTableId </ChunkName>
 196                 <TotalDataNodes> 0 </TotalDataNodes>
 197                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 198                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 199         <Chunk Id> 11 </Chunk Id>
 200                 <TotalPages> 1 </TotalPages>
 201                 <ChunkName > UserTableId </ChunkName>
 202                 <TotalDataNodes> 2 </TotalDataNodes>
 203                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 204                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 205         <Chunk Id> 12 </Chunk Id>
 206                 <TotalPages> 1 </TotalPages>
 207                 <ChunkName > TableTableId </ChunkName>
 208                 <TotalDataNodes> 1 </TotalDataNodes>
 209                 <SizeOfDataNodes> 92 </SizeOfDataNodes>
 210                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 211         <Chunk Id> 13 </Chunk Id>
 212                 <TotalPages> 1 </TotalPages>
 213                 <ChunkName > FieldTableId </ChunkName>
 214                 <TotalDataNodes> 3 </TotalDataNodes>
 215                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 216                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 217         <Chunk Id> 14 </Chunk Id>
 218                 <TotalPages> 1 </TotalPages>
 219                 <ChunkName > AccessTableId </ChunkName>
 220                 <TotalDataNodes> 0 </TotalDataNodes>
 221                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 222                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 223         <Chunk Id> 15 </Chunk Id>
 224                 <TotalPages> 1 </TotalPages>
 225                 <ChunkName > IndexTableId </ChunkName>
 226                 <TotalDataNodes> 2 </TotalDataNodes>
 227                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 228                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 229         <Chunk Id> 16 </Chunk Id>
 230                 <TotalPages> 1 </TotalPages>
 231                 <ChunkName > IndexFieldTableId </ChunkName>
 232                 <TotalDataNodes> 2 </TotalDataNodes>
 233                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 234                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 235         <Chunk Id> 17 </Chunk Id>
 236                 <TotalPages> 1 </TotalPages>
 237                 <ChunkName > ForeignKeyTableId </ChunkName>
 238                 <TotalDataNodes> 0 </TotalDataNodes>
 239                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
 240                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 241         <Chunk Id> 18 </Chunk Id>
 242                 <TotalPages> 1 </TotalPages>
 243                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
 244                 <TotalDataNodes> 0 </TotalDataNodes>
 245                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 246                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 247   </System Chunk >
 248   <User Chunk >
 249         <Chunk Id> 101 </Chunk Id>
 250                 <TotalPages> 1 </TotalPages>
 251                 <ChunkName > t2 </ChunkName>
 252                 <TotalDataNodes> 20 </TotalDataNodes>
 253                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 254                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 255         <Chunk Id> 102 </Chunk Id>
 256                 <TotalPages> 1 </TotalPages>
 257                 <ChunkName > t2_idx1_Primary </ChunkName>
 258                 <TotalDataNodes> 1 </TotalDataNodes>
 259                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 260                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 261         <Chunk Id> 103 </Chunk Id>
 262                 <TotalPages> 1 </TotalPages>
 263                 <ChunkName > t2_idx1_Primary </ChunkName>
 264                 <TotalDataNodes> 20 </TotalDataNodes>
 265                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 266                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 267         <Chunk Id> 104 </Chunk Id>
 268                 <TotalPages> 1 </TotalPages>
 269                 <ChunkName > t2Uniqueidx </ChunkName>
 270                 <TotalDataNodes> 1 </TotalDataNodes>
 271                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 272                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 273         <Chunk Id> 105 </Chunk Id>
 274                 <TotalPages> 1 </TotalPages>
 275                 <ChunkName > t2Uniqueidx </ChunkName>
 276                 <TotalDataNodes> 20 </TotalDataNodes>
 277                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 278                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 279   </User Chunk >
 280 </Chunk information>
 281 echo delete 10 tuples;
 282 Statement Executed: Rows Affected = 10
 283 10 tuples deleted
 284 Case 3: With -D chunk option after deleting 10 tuples :
 285 <Chunk information>
 286   <System Chunk >
 287         <Chunk Id> 0 </Chunk Id>
 288                 <TotalPages> 1 </TotalPages>
 289                 <ChunkName > UserChunkTableId </ChunkName>
 290                 <TotalDataNodes> 5 </TotalDataNodes>
 291                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 292                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 293         <Chunk Id> 1 </Chunk Id>
 294                 <TotalPages> 1 </TotalPages>
 295                 <ChunkName > LockTableHashBucketId </ChunkName>
 296                 <TotalDataNodes> 1 </TotalDataNodes>
 297                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 298                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 299         <Chunk Id> 2 </Chunk Id>
 300                 <TotalPages> 1 </TotalPages>
 301                 <ChunkName > LockTableMutexId </ChunkName>
 302                 <TotalDataNodes> 0 </TotalDataNodes>
 303                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 304                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 305         <Chunk Id> 3 </Chunk Id>
 306                 <TotalPages> 1 </TotalPages>
 307                 <ChunkName > LockTableId </ChunkName>
 308                 <TotalDataNodes> 0 </TotalDataNodes>
 309                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
 310                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 311         <Chunk Id> 4 </Chunk Id>
 312                 <TotalPages> 1 </TotalPages>
 313                 <ChunkName > TransHasTableId </ChunkName>
 314                 <TotalDataNodes> 0 </TotalDataNodes>
 315                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 316                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 317         <Chunk Id> 5 </Chunk Id>
 318                 <TotalPages> 1 </TotalPages>
 319                 <ChunkName > UndoLogTableId </ChunkName>
 320                 <TotalDataNodes> 0 </TotalDataNodes>
 321                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 322                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 323         <Chunk Id> 10 </Chunk Id>
 324                 <TotalPages> 1 </TotalPages>
 325                 <ChunkName > DatabaseTableId </ChunkName>
 326                 <TotalDataNodes> 0 </TotalDataNodes>
 327                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 328                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 329         <Chunk Id> 11 </Chunk Id>
 330                 <TotalPages> 1 </TotalPages>
 331                 <ChunkName > UserTableId </ChunkName>
 332                 <TotalDataNodes> 2 </TotalDataNodes>
 333                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 334                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 335         <Chunk Id> 12 </Chunk Id>
 336                 <TotalPages> 1 </TotalPages>
 337                 <ChunkName > TableTableId </ChunkName>
 338                 <TotalDataNodes> 1 </TotalDataNodes>
 339                 <SizeOfDataNodes> 92 </SizeOfDataNodes>
 340                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 341         <Chunk Id> 13 </Chunk Id>
 342                 <TotalPages> 1 </TotalPages>
 343                 <ChunkName > FieldTableId </ChunkName>
 344                 <TotalDataNodes> 3 </TotalDataNodes>
 345                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 346                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 347         <Chunk Id> 14 </Chunk Id>
 348                 <TotalPages> 1 </TotalPages>
 349                 <ChunkName > AccessTableId </ChunkName>
 350                 <TotalDataNodes> 0 </TotalDataNodes>
 351                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 352                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 353         <Chunk Id> 15 </Chunk Id>
 354                 <TotalPages> 1 </TotalPages>
 355                 <ChunkName > IndexTableId </ChunkName>
 356                 <TotalDataNodes> 2 </TotalDataNodes>
 357                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 358                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 359         <Chunk Id> 16 </Chunk Id>
 360                 <TotalPages> 1 </TotalPages>
 361                 <ChunkName > IndexFieldTableId </ChunkName>
 362                 <TotalDataNodes> 2 </TotalDataNodes>
 363                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 364                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 365         <Chunk Id> 17 </Chunk Id>
 366                 <TotalPages> 1 </TotalPages>
 367                 <ChunkName > ForeignKeyTableId </ChunkName>
 368                 <TotalDataNodes> 0 </TotalDataNodes>
 369                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
 370                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 371         <Chunk Id> 18 </Chunk Id>
 372                 <TotalPages> 1 </TotalPages>
 373                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
 374                 <TotalDataNodes> 0 </TotalDataNodes>
 375                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 376                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 377   </System Chunk >
 378   <User Chunk >
 379         <Chunk Id> 101 </Chunk Id>
 380                 <TotalPages> 1 </TotalPages>
 381                 <ChunkName > t2 </ChunkName>
 382                 <TotalDataNodes> 10 </TotalDataNodes>
 383                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 384                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 385         <Chunk Id> 102 </Chunk Id>
 386                 <TotalPages> 1 </TotalPages>
 387                 <ChunkName > t2_idx1_Primary </ChunkName>
 388                 <TotalDataNodes> 1 </TotalDataNodes>
 389                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 390                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 391         <Chunk Id> 103 </Chunk Id>
 392                 <TotalPages> 1 </TotalPages>
 393                 <ChunkName > t2_idx1_Primary </ChunkName>
 394                 <TotalDataNodes> 10 </TotalDataNodes>
 395                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 396                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 397         <Chunk Id> 104 </Chunk Id>
 398                 <TotalPages> 1 </TotalPages>
 399                 <ChunkName > t2Uniqueidx </ChunkName>
 400                 <TotalDataNodes> 1 </TotalDataNodes>
 401                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 402                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 403         <Chunk Id> 105 </Chunk Id>
 404                 <TotalPages> 1 </TotalPages>
 405                 <ChunkName > t2Uniqueidx </ChunkName>
 406                 <TotalDataNodes> 10 </TotalDataNodes>
 407                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 408                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 409   </User Chunk >
 410 </Chunk information>
 411 echo drop index t2Uniqueidx;
 412 Statement Executed
 413 Index droped
 414 Case 4: With -D chunk  option after Index droped :
 415 <Chunk information>
 416   <System Chunk >
 417         <Chunk Id> 0 </Chunk Id>
 418                 <TotalPages> 1 </TotalPages>
 419                 <ChunkName > UserChunkTableId </ChunkName>
 420                 <TotalDataNodes> 3 </TotalDataNodes>
 421                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 422                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 423         <Chunk Id> 1 </Chunk Id>
 424                 <TotalPages> 1 </TotalPages>
 425                 <ChunkName > LockTableHashBucketId </ChunkName>
 426                 <TotalDataNodes> 1 </TotalDataNodes>
 427                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 428                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 429         <Chunk Id> 2 </Chunk Id>
 430                 <TotalPages> 1 </TotalPages>
 431                 <ChunkName > LockTableMutexId </ChunkName>
 432                 <TotalDataNodes> 0 </TotalDataNodes>
 433                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 434                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 435         <Chunk Id> 3 </Chunk Id>
 436                 <TotalPages> 1 </TotalPages>
 437                 <ChunkName > LockTableId </ChunkName>
 438                 <TotalDataNodes> 0 </TotalDataNodes>
 439                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
 440                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 441         <Chunk Id> 4 </Chunk Id>
 442                 <TotalPages> 1 </TotalPages>
 443                 <ChunkName > TransHasTableId </ChunkName>
 444                 <TotalDataNodes> 0 </TotalDataNodes>
 445                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 446                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 447         <Chunk Id> 5 </Chunk Id>
 448                 <TotalPages> 1 </TotalPages>
 449                 <ChunkName > UndoLogTableId </ChunkName>
 450                 <TotalDataNodes> 0 </TotalDataNodes>
 451                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 452                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 453         <Chunk Id> 10 </Chunk Id>
 454                 <TotalPages> 1 </TotalPages>
 455                 <ChunkName > DatabaseTableId </ChunkName>
 456                 <TotalDataNodes> 0 </TotalDataNodes>
 457                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 458                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 459         <Chunk Id> 11 </Chunk Id>
 460                 <TotalPages> 1 </TotalPages>
 461                 <ChunkName > UserTableId </ChunkName>
 462                 <TotalDataNodes> 2 </TotalDataNodes>
 463                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 464                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 465         <Chunk Id> 12 </Chunk Id>
 466                 <TotalPages> 1 </TotalPages>
 467                 <ChunkName > TableTableId </ChunkName>
 468                 <TotalDataNodes> 1 </TotalDataNodes>
 469                 <SizeOfDataNodes> 92 </SizeOfDataNodes>
 470                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 471         <Chunk Id> 13 </Chunk Id>
 472                 <TotalPages> 1 </TotalPages>
 473                 <ChunkName > FieldTableId </ChunkName>
 474                 <TotalDataNodes> 3 </TotalDataNodes>
 475                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 476                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 477         <Chunk Id> 14 </Chunk Id>
 478                 <TotalPages> 1 </TotalPages>
 479                 <ChunkName > AccessTableId </ChunkName>
 480                 <TotalDataNodes> 0 </TotalDataNodes>
 481                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 482                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 483         <Chunk Id> 15 </Chunk Id>
 484                 <TotalPages> 1 </TotalPages>
 485                 <ChunkName > IndexTableId </ChunkName>
 486                 <TotalDataNodes> 1 </TotalDataNodes>
 487                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 488                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 489         <Chunk Id> 16 </Chunk Id>
 490                 <TotalPages> 1 </TotalPages>
 491                 <ChunkName > IndexFieldTableId </ChunkName>
 492                 <TotalDataNodes> 1 </TotalDataNodes>
 493                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 494                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 495         <Chunk Id> 17 </Chunk Id>
 496                 <TotalPages> 1 </TotalPages>
 497                 <ChunkName > ForeignKeyTableId </ChunkName>
 498                 <TotalDataNodes> 0 </TotalDataNodes>
 499                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
 500                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 501         <Chunk Id> 18 </Chunk Id>
 502                 <TotalPages> 1 </TotalPages>
 503                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
 504                 <TotalDataNodes> 0 </TotalDataNodes>
 505                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 506                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 507   </System Chunk >
 508   <User Chunk >
 509         <Chunk Id> 101 </Chunk Id>
 510                 <TotalPages> 1 </TotalPages>
 511                 <ChunkName > t2 </ChunkName>
 512                 <TotalDataNodes> 10 </TotalDataNodes>
 513                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 514                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 515         <Chunk Id> 102 </Chunk Id>
 516                 <TotalPages> 1 </TotalPages>
 517                 <ChunkName > t2_idx1_Primary </ChunkName>
 518                 <TotalDataNodes> 1 </TotalDataNodes>
 519                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 520                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 521         <Chunk Id> 103 </Chunk Id>
 522                 <TotalPages> 1 </TotalPages>
 523                 <ChunkName > t2_idx1_Primary </ChunkName>
 524                 <TotalDataNodes> 10 </TotalDataNodes>
 525                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 526                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 527   </User Chunk >
 528 </Chunk information>
 529 echo  drop table t2;
 530 Statement Executed
 531 t2 table droped with index
 532 Case 5: With -D chunk  option after drop t2 :
 533 <Chunk information>
 534   <System Chunk >
 535         <Chunk Id> 0 </Chunk Id>
 536                 <TotalPages> 1 </TotalPages>
 537                 <ChunkName > UserChunkTableId </ChunkName>
 538                 <TotalDataNodes> 0 </TotalDataNodes>
 539                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 540                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 541         <Chunk Id> 1 </Chunk Id>
 542                 <TotalPages> 1 </TotalPages>
 543                 <ChunkName > LockTableHashBucketId </ChunkName>
 544                 <TotalDataNodes> 1 </TotalDataNodes>
 545                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 546                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 547         <Chunk Id> 2 </Chunk Id>
 548                 <TotalPages> 1 </TotalPages>
 549                 <ChunkName > LockTableMutexId </ChunkName>
 550                 <TotalDataNodes> 0 </TotalDataNodes>
 551                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 552                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 553         <Chunk Id> 3 </Chunk Id>
 554                 <TotalPages> 1 </TotalPages>
 555                 <ChunkName > LockTableId </ChunkName>
 556                 <TotalDataNodes> 0 </TotalDataNodes>
 557                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
 558                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 559         <Chunk Id> 4 </Chunk Id>
 560                 <TotalPages> 1 </TotalPages>
 561                 <ChunkName > TransHasTableId </ChunkName>
 562                 <TotalDataNodes> 0 </TotalDataNodes>
 563                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 564                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 565         <Chunk Id> 5 </Chunk Id>
 566                 <TotalPages> 1 </TotalPages>
 567                 <ChunkName > UndoLogTableId </ChunkName>
 568                 <TotalDataNodes> 0 </TotalDataNodes>
 569                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 570                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 571         <Chunk Id> 10 </Chunk Id>
 572                 <TotalPages> 1 </TotalPages>
 573                 <ChunkName > DatabaseTableId </ChunkName>
 574                 <TotalDataNodes> 0 </TotalDataNodes>
 575                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 576                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 577         <Chunk Id> 11 </Chunk Id>
 578                 <TotalPages> 1 </TotalPages>
 579                 <ChunkName > UserTableId </ChunkName>
 580                 <TotalDataNodes> 2 </TotalDataNodes>
 581                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 582                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 583         <Chunk Id> 12 </Chunk Id>
 584                 <TotalPages> 1 </TotalPages>
 585                 <ChunkName > TableTableId </ChunkName>
 586                 <TotalDataNodes> 0 </TotalDataNodes>
 587                 <SizeOfDataNodes> 92 </SizeOfDataNodes>
 588                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 589         <Chunk Id> 13 </Chunk Id>
 590                 <TotalPages> 1 </TotalPages>
 591                 <ChunkName > FieldTableId </ChunkName>
 592                 <TotalDataNodes> 0 </TotalDataNodes>
 593                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 594                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 595         <Chunk Id> 14 </Chunk Id>
 596                 <TotalPages> 1 </TotalPages>
 597                 <ChunkName > AccessTableId </ChunkName>
 598                 <TotalDataNodes> 0 </TotalDataNodes>
 599                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 600                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 601         <Chunk Id> 15 </Chunk Id>
 602                 <TotalPages> 1 </TotalPages>
 603                 <ChunkName > IndexTableId </ChunkName>
 604                 <TotalDataNodes> 0 </TotalDataNodes>
 605                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 606                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 607         <Chunk Id> 16 </Chunk Id>
 608                 <TotalPages> 1 </TotalPages>
 609                 <ChunkName > IndexFieldTableId </ChunkName>
 610                 <TotalDataNodes> 0 </TotalDataNodes>
 611                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 612                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 613         <Chunk Id> 17 </Chunk Id>
 614                 <TotalPages> 1 </TotalPages>
 615                 <ChunkName > ForeignKeyTableId </ChunkName>
 616                 <TotalDataNodes> 0 </TotalDataNodes>
 617                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
 618                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 619         <Chunk Id> 18 </Chunk Id>
 620                 <TotalPages> 1 </TotalPages>
 621                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
 622                 <TotalDataNodes> 0 </TotalDataNodes>
 623                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 624                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 625   </System Chunk >
 626   <User Chunk >
 627   </User Chunk >
 628 </Chunk information>