test/tools/csql/exp.test099.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 Statement Executed: Rows Affected = 1
  13 ---------------------------------------------------------
  14         t1.f1
  15 ---------------------------------------------------------
  16         wraFASDvgaserrerqwe
  17         wraFASDvgaserrerqwe
  18         wraFASDvgaserrerqwe
  19         wraFASDvgaserrerqwe
  20         wraFASDvgaserrerqwe
  21         wraFASDvgaserrerqwe
  22         wraFASDvgaserrerqwe
  23         wraFASDvgaserrerqwe
  24         wraFASDvgaserrerqwe
  25         wraFASDvgaserrerqwe
  26         wraFASDvgaserrerqwe
  27
  28 Statement Executed: Rows Affected = 11
  29 ---------------------------------------------------------
  30         t1.f1
  31 ---------------------------------------------------------
  32
  33 Statement Executed
  34 Statement Executed: Rows Affected = 1
  35 Statement Executed: Rows Affected = 1
  36 Statement Executed: Rows Affected = 1
  37 Statement Executed: Rows Affected = 1
  38 Statement Executed: Rows Affected = 1
  39 Statement Executed: Rows Affected = 1
  40 Statement Executed: Rows Affected = 1
  41 Statement Executed: Rows Affected = 1
  42 Statement Executed: Rows Affected = 1
  43 Statement Executed: Rows Affected = 1
  44 Statement Executed: Rows Affected = 1
  45 Statement Executed: Rows Affected = 1
  46 Statement Executed: Rows Affected = 1
  47 Statement Executed: Rows Affected = 1
  48 ---------------------------------------------------------
  49         t2.f1   t2.f2
  50 ---------------------------------------------------------
  51         1232    2342sfvdf
  52         1232    2342sfvdf
  53         1232    2342sfvdf
  54         1232    2342sfvdf
  55         1232    2342sfvdf
  56         1232    2342sfvdf
  57         1232    2342sfvdf
  58         1232    2342sfvdf
  59         1232    2342sfvdf
  60         1232    2342sfvdf
  61
  62 ---------------------------------------------------------
  63         t1.f1
  64 ---------------------------------------------------------
  65         wraFASDvgaserrerqwe
  66         wraFASDvgaserrerqwe
  67         wraFASDvgaserrerqwe
  68         wraFASDvgaserrerqwe
  69
  70 Statement Executed: Rows Affected = 1
  71 Statement Executed: Rows Affected = 1
  72 Statement Executed: Rows Affected = 1
  73 Statement Executed: Rows Affected = 1
  74 Statement Executed: Rows Affected = 1
  75 Statement Executed: Rows Affected = 1
  76 ---------------------------------------------------------
  77         t2.f1   t2.f2
  78 ---------------------------------------------------------
  79         1232    2342sfvdf
  80         1232    2342sfvdf
  81         1232    2342sfvdf
  82         1232    2342sfvdf
  83         1232    2342sfvdf
  84         1232    2342sfvdf
  85         1232    2342sfvdf
  86         1232    2342sfvdf
  87         1232    2342sfvdf
  88         1232    2342sfvdf
  89         1232    2342sfvdf
  90         1232    2342sfvdf
  91         1232    2342sfvdf
  92         1232    2342sfvdf
  93
  94 ---------------------------------------------------------
  95         t1.f1
  96 ---------------------------------------------------------
  97         wraFASDvgaserrerqwe
  98         wraFASDvgaserrerqwe
  99         wraFASDvgaserrerqwe
 100         wraFASDvgaserrerqwe
 101         wraFASDvgaserrerqwe
 102         wraFASDvgaserrerqwe
 103
 104 <Chunk information>
 105   <System Chunk >
 106         <Chunk Id> 0 </Chunk Id>
 107                 <TotalPages> 1 </TotalPages>
 108                 <ChunkName > UserChunkTableId </ChunkName>
 109                 <TotalDataNodes> 2 </TotalDataNodes>
 110                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 111                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 112         <Chunk Id> 1 </Chunk Id>
 113                 <TotalPages> 1 </TotalPages>
 114                 <ChunkName > LockTableHashBucketId </ChunkName>
 115                 <TotalDataNodes> 1 </TotalDataNodes>
 116                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 117                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 118         <Chunk Id> 2 </Chunk Id>
 119                 <TotalPages> 1 </TotalPages>
 120                 <ChunkName > LockTableMutexId </ChunkName>
 121                 <TotalDataNodes> 0 </TotalDataNodes>
 122                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 123                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 124         <Chunk Id> 3 </Chunk Id>
 125                 <TotalPages> 1 </TotalPages>
 126                 <ChunkName > LockTableId </ChunkName>
 127                 <TotalDataNodes> 0 </TotalDataNodes>
 128                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
 129                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 130         <Chunk Id> 4 </Chunk Id>
 131                 <TotalPages> 1 </TotalPages>
 132                 <ChunkName > TransHasTableId </ChunkName>
 133                 <TotalDataNodes> 0 </TotalDataNodes>
 134                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 135                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 136         <Chunk Id> 5 </Chunk Id>
 137                 <TotalPages> 1 </TotalPages>
 138                 <ChunkName > UndoLogTableId </ChunkName>
 139                 <TotalDataNodes> 0 </TotalDataNodes>
 140                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 141                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 142         <Chunk Id> 10 </Chunk Id>
 143                 <TotalPages> 1 </TotalPages>
 144                 <ChunkName > DatabaseTableId </ChunkName>
 145                 <TotalDataNodes> 0 </TotalDataNodes>
 146                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 147                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 148         <Chunk Id> 11 </Chunk Id>
 149                 <TotalPages> 1 </TotalPages>
 150                 <ChunkName > UserTableId </ChunkName>
 151                 <TotalDataNodes> 2 </TotalDataNodes>
 152                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 153                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 154         <Chunk Id> 12 </Chunk Id>
 155                 <TotalPages> 1 </TotalPages>
 156                 <ChunkName > TableTableId </ChunkName>
 157                 <TotalDataNodes> 2 </TotalDataNodes>
 158                 <SizeOfDataNodes> 88 </SizeOfDataNodes>
 159                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 160         <Chunk Id> 13 </Chunk Id>
 161                 <TotalPages> 1 </TotalPages>
 162                 <ChunkName > FieldTableId </ChunkName>
 163                 <TotalDataNodes> 3 </TotalDataNodes>
 164                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 165                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 166         <Chunk Id> 14 </Chunk Id>
 167                 <TotalPages> 1 </TotalPages>
 168                 <ChunkName > AccessTableId </ChunkName>
 169                 <TotalDataNodes> 0 </TotalDataNodes>
 170                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 171                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 172         <Chunk Id> 15 </Chunk Id>
 173                 <TotalPages> 1 </TotalPages>
 174                 <ChunkName > IndexTableId </ChunkName>
 175                 <TotalDataNodes> 0 </TotalDataNodes>
 176                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 177                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 178         <Chunk Id> 16 </Chunk Id>
 179                 <TotalPages> 1 </TotalPages>
 180                 <ChunkName > IndexFieldTableId </ChunkName>
 181                 <TotalDataNodes> 0 </TotalDataNodes>
 182                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 183                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 184         <Chunk Id> 17 </Chunk Id>
 185                 <TotalPages> 1 </TotalPages>
 186                 <ChunkName > ForeignKeyTableId </ChunkName>
 187                 <TotalDataNodes> 0 </TotalDataNodes>
 188                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
 189                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 190         <Chunk Id> 18 </Chunk Id>
 191                 <TotalPages> 1 </TotalPages>
 192                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
 193                 <TotalDataNodes> 0 </TotalDataNodes>
 194                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 195                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 196   </System Chunk >
 197   <User Chunk >
 198         <Chunk Id> 101 </Chunk Id>
 199                 <TotalPages> 7 </TotalPages>
 200                 <ChunkName > t1 </ChunkName>
 201                 <TotalDataNodes> 6 </TotalDataNodes>
 202                 <SizeOfDataNodes> 10008 </SizeOfDataNodes>
 203                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 204         <Chunk Id> 102 </Chunk Id>
 205                 <TotalPages> 1 </TotalPages>
 206                 <ChunkName > t2 </ChunkName>
 207                 <TotalDataNodes> 14 </TotalDataNodes>
 208                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
 209                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 210   </User Chunk >
 211 </Chunk information>
 212 <Database Usage Statistics>
 213 <DatabaseStatistics>
 214   <Database Name>  SYSTEMDB </Database Name>
 215   <Max Size> 1048576 </Max Size>
 216   <First Page> 17d84000 </First Page>
 217   <Total Pages> 109 </Total Pages>
 218   <Used Normal Pages> 13 </Used Normal Pages>
 219   <Used Merged Pages> 2 </Used Merged Pages>
 220   <Chunks Used> 15 </Chunks Used>
 221 </DatabaseStatistics>
 222 <ProcTable>
 223   <UsedSlots> 1 </UsedSlots>
 224   <FreeSlots> 99 </FreeSlots>
 225 </ProcTable>
 226 <TransactionTable>
 227   <UsedSlots> 0 </UsedSlots>
 228   <FreeSlots> 100 </FreeSlots>
 229   <UndoLogs>
 230     <TotalNodes> 0 </TotalNodes>
 231   </UndoLogs>
 232 </TransactionTable>
 233 <LockTable>
 234   <TotalBuckets> 2048  </TotalBuckets>
 235   <UsedBuckets> 0  </UsedBuckets>
 236   <TotalLockNodes> 0  </TotalLockNodes>
 237 </LockTable>
 238 <DatabaseStatistics>
 239   <Database Name>  userdb </Database Name>
 240   <Max Size> 10485760 </Max Size>
 241   <First Page> 17e7a000 </First Page>
 242   <Total Pages> 1272 </Total Pages>
 243   <Used Normal Pages> 1 </Used Normal Pages>
 244   <Used Merged Pages> 7 </Used Merged Pages>
 245   <Chunks Used> 2 </Chunks Used>
 246 </DatabaseStatistics>
 247 </Database Usage Statistics>
 248 Statement Executed
 249 Statement Executed