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> 20 </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> 1 </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> 88 </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   </System Chunk >
  83   <User Chunk >
  84   </User Chunk >
  85 </Chunk information>
  86 echo create table and constraints with integer fields;
  87 Statement Executed
  88 Statement Executed: Rows Affected = 1
  89 Statement Executed: Rows Affected = 1
  90 Statement Executed: Rows Affected = 1
  91 Statement Executed: Rows Affected = 1
  92 Statement Executed: Rows Affected = 1
  93 Statement Executed: Rows Affected = 1
  94 Statement Executed: Rows Affected = 1
  95 Statement Executed: Rows Affected = 1
  96 Statement Executed: Rows Affected = 1
  97 Statement Executed: Rows Affected = 1
  98 Case 2: With -D chunk  option after table creation:
  99 <Chunk information>
 100   <System Chunk >
 101         <Chunk Id> 0 </Chunk Id>
 102                 <TotalPages> 1 </TotalPages>
 103                 <ChunkName > UserChunkTableId </ChunkName>
 104                 <TotalDataNodes> 1 </TotalDataNodes>
 105                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 106                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 107         <Chunk Id> 1 </Chunk Id>
 108                 <TotalPages> 1 </TotalPages>
 109                 <ChunkName > LockTableHashBucketId </ChunkName>
 110                 <TotalDataNodes> 1 </TotalDataNodes>
 111                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 112                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 113         <Chunk Id> 2 </Chunk Id>
 114                 <TotalPages> 1 </TotalPages>
 115                 <ChunkName > LockTableMutexId </ChunkName>
 116                 <TotalDataNodes> 0 </TotalDataNodes>
 117                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 118                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 119         <Chunk Id> 3 </Chunk Id>
 120                 <TotalPages> 1 </TotalPages>
 121                 <ChunkName > LockTableId </ChunkName>
 122                 <TotalDataNodes> 0 </TotalDataNodes>
 123                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 124                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 125         <Chunk Id> 4 </Chunk Id>
 126                 <TotalPages> 1 </TotalPages>
 127                 <ChunkName > TransHasTableId </ChunkName>
 128                 <TotalDataNodes> 0 </TotalDataNodes>
 129                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 130                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 131         <Chunk Id> 5 </Chunk Id>
 132                 <TotalPages> 1 </TotalPages>
 133                 <ChunkName > UndoLogTableId </ChunkName>
 134                 <TotalDataNodes> 0 </TotalDataNodes>
 135                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 136                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 137         <Chunk Id> 10 </Chunk Id>
 138                 <TotalPages> 1 </TotalPages>
 139                 <ChunkName > DatabaseTableId </ChunkName>
 140                 <TotalDataNodes> 0 </TotalDataNodes>
 141                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 142                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 143         <Chunk Id> 11 </Chunk Id>
 144                 <TotalPages> 1 </TotalPages>
 145                 <ChunkName > UserTableId </ChunkName>
 146                 <TotalDataNodes> 1 </TotalDataNodes>
 147                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 148                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 149         <Chunk Id> 12 </Chunk Id>
 150                 <TotalPages> 1 </TotalPages>
 151                 <ChunkName > TableTableId </ChunkName>
 152                 <TotalDataNodes> 1 </TotalDataNodes>
 153                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
 154                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 155         <Chunk Id> 13 </Chunk Id>
 156                 <TotalPages> 1 </TotalPages>
 157                 <ChunkName > FieldTableId </ChunkName>
 158                 <TotalDataNodes> 2 </TotalDataNodes>
 159                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 160                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 161         <Chunk Id> 14 </Chunk Id>
 162                 <TotalPages> 1 </TotalPages>
 163                 <ChunkName > AccessTableId </ChunkName>
 164                 <TotalDataNodes> 0 </TotalDataNodes>
 165                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 166                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 167         <Chunk Id> 15 </Chunk Id>
 168                 <TotalPages> 1 </TotalPages>
 169                 <ChunkName > IndexTableId </ChunkName>
 170                 <TotalDataNodes> 0 </TotalDataNodes>
 171                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 172                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 173         <Chunk Id> 16 </Chunk Id>
 174                 <TotalPages> 1 </TotalPages>
 175                 <ChunkName > IndexFieldTableId </ChunkName>
 176                 <TotalDataNodes> 0 </TotalDataNodes>
 177                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 178                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 179   </System Chunk >
 180   <User Chunk >
 181         <Chunk Id> 101 </Chunk Id>
 182                 <TotalPages> 1 </TotalPages>
 183                 <ChunkName > t1 </ChunkName>
 184                 <TotalDataNodes> 10 </TotalDataNodes>
 185                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 186                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 187   </User Chunk >
 188 </Chunk information>
 189 echo  drop table t1;
 190 Statement Executed
 191 t1 table droped
 192 Case 3: With -D chunk  option after drop t1 :
 193 <Chunk information>
 194   <System Chunk >
 195         <Chunk Id> 0 </Chunk Id>
 196                 <TotalPages> 1 </TotalPages>
 197                 <ChunkName > UserChunkTableId </ChunkName>
 198                 <TotalDataNodes> 0 </TotalDataNodes>
 199                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 200                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 201         <Chunk Id> 1 </Chunk Id>
 202                 <TotalPages> 1 </TotalPages>
 203                 <ChunkName > LockTableHashBucketId </ChunkName>
 204                 <TotalDataNodes> 1 </TotalDataNodes>
 205                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 206                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 207         <Chunk Id> 2 </Chunk Id>
 208                 <TotalPages> 1 </TotalPages>
 209                 <ChunkName > LockTableMutexId </ChunkName>
 210                 <TotalDataNodes> 0 </TotalDataNodes>
 211                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 212                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 213         <Chunk Id> 3 </Chunk Id>
 214                 <TotalPages> 1 </TotalPages>
 215                 <ChunkName > LockTableId </ChunkName>
 216                 <TotalDataNodes> 0 </TotalDataNodes>
 217                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 218                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 219         <Chunk Id> 4 </Chunk Id>
 220                 <TotalPages> 1 </TotalPages>
 221                 <ChunkName > TransHasTableId </ChunkName>
 222                 <TotalDataNodes> 0 </TotalDataNodes>
 223                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 224                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 225         <Chunk Id> 5 </Chunk Id>
 226                 <TotalPages> 1 </TotalPages>
 227                 <ChunkName > UndoLogTableId </ChunkName>
 228                 <TotalDataNodes> 0 </TotalDataNodes>
 229                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 230                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 231         <Chunk Id> 10 </Chunk Id>
 232                 <TotalPages> 1 </TotalPages>
 233                 <ChunkName > DatabaseTableId </ChunkName>
 234                 <TotalDataNodes> 0 </TotalDataNodes>
 235                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 236                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 237         <Chunk Id> 11 </Chunk Id>
 238                 <TotalPages> 1 </TotalPages>
 239                 <ChunkName > UserTableId </ChunkName>
 240                 <TotalDataNodes> 1 </TotalDataNodes>
 241                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 242                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 243         <Chunk Id> 12 </Chunk Id>
 244                 <TotalPages> 1 </TotalPages>
 245                 <ChunkName > TableTableId </ChunkName>
 246                 <TotalDataNodes> 0 </TotalDataNodes>
 247                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
 248                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 249         <Chunk Id> 13 </Chunk Id>
 250                 <TotalPages> 1 </TotalPages>
 251                 <ChunkName > FieldTableId </ChunkName>
 252                 <TotalDataNodes> 0 </TotalDataNodes>
 253                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 254                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 255         <Chunk Id> 14 </Chunk Id>
 256                 <TotalPages> 1 </TotalPages>
 257                 <ChunkName > AccessTableId </ChunkName>
 258                 <TotalDataNodes> 0 </TotalDataNodes>
 259                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 260                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 261         <Chunk Id> 15 </Chunk Id>
 262                 <TotalPages> 1 </TotalPages>
 263                 <ChunkName > IndexTableId </ChunkName>
 264                 <TotalDataNodes> 0 </TotalDataNodes>
 265                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 266                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 267         <Chunk Id> 16 </Chunk Id>
 268                 <TotalPages> 1 </TotalPages>
 269                 <ChunkName > IndexFieldTableId </ChunkName>
 270                 <TotalDataNodes> 0 </TotalDataNodes>
 271                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 272                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 273   </System Chunk >
 274   <User Chunk >
 275   </User Chunk >
 276 </Chunk information>