test/tools/catalog/exp.test005.ksh

   1 Case 1: With -D chunk option with empty database
   2 <Chunk information>
   3   <System Chunk >
   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>
  94   </System Chunk >
  95   <User Chunk >
  96   </User Chunk >
  97 </Chunk information>
  98 echo create table and constraints with integer fields;
  99 Statement Executed
 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:
 111 <Chunk information>
 112   <System Chunk >
 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>
 203   </System Chunk >
 204   <User Chunk >
 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>
 211   </User Chunk >
 212 </Chunk information>
 213 echo  drop table t1;
 214 Statement Executed
 215 t1 table droped
 216 Case 3: With -D chunk  option after drop t1 :
 217 <Chunk information>
 218   <System Chunk >
 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>
 309   </System Chunk >
 310   <User Chunk >
 311   </User Chunk >
 312 </Chunk information>