test/tools/csql/exp.test131.ksh

   1 echo CREATE TABLE t1(f1 int,f2 int);
   2 Statement Executed
   3 echo CREATE INDEX idx1 on t1(f1);
   4 Statement Executed
   5 echo SET AUTOCOMMIT OFF;
   6 AUTOCOMMIT Mode is set to OFF
   7 echo INSERT INTO t1 VALUES(1,10);
   8 Statement Executed: Rows Affected = 1
   9 echo INSERT INTO t1 VALUES(2,20);
  10 Statement Executed: Rows Affected = 1
  11 echo INSERT INTO t1 VALUES(3,30);
  12 Statement Executed: Rows Affected = 1
  13 echo INSERT INTO t1 VALUES(4,40);
  14 Statement Executed: Rows Affected = 1
  15 echo INSERT INTO t1 VALUES(5,50);
  16 Statement Executed: Rows Affected = 1
  17 echo COMMIT;
  18 <Chunk information>
  19   <System Chunk >
  20         <Chunk Id> 0 </Chunk Id>
  21                 <TotalPages> 1 </TotalPages>
  22                 <ChunkName > UserChunkTableId </ChunkName>
  23                 <TotalDataNodes> 3 </TotalDataNodes>
  24                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
  25                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  26         <Chunk Id> 1 </Chunk Id>
  27                 <TotalPages> 1 </TotalPages>
  28                 <ChunkName > LockTableHashBucketId </ChunkName>
  29                 <TotalDataNodes> 1 </TotalDataNodes>
  30                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
  31                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  32         <Chunk Id> 2 </Chunk Id>
  33                 <TotalPages> 1 </TotalPages>
  34                 <ChunkName > LockTableMutexId </ChunkName>
  35                 <TotalDataNodes> 0 </TotalDataNodes>
  36                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
  37                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  38         <Chunk Id> 3 </Chunk Id>
  39                 <TotalPages> 1 </TotalPages>
  40                 <ChunkName > LockTableId </ChunkName>
  41                 <TotalDataNodes> 0 </TotalDataNodes>
  42                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
  43                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  44         <Chunk Id> 4 </Chunk Id>
  45                 <TotalPages> 1 </TotalPages>
  46                 <ChunkName > TransHasTableId </ChunkName>
  47                 <TotalDataNodes> 0 </TotalDataNodes>
  48                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
  49                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  50         <Chunk Id> 5 </Chunk Id>
  51                 <TotalPages> 1 </TotalPages>
  52                 <ChunkName > UndoLogTableId </ChunkName>
  53                 <TotalDataNodes> 0 </TotalDataNodes>
  54                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
  55                 <Allocation Type> VariableSizeAllocator </Allocation Type>
  56         <Chunk Id> 10 </Chunk Id>
  57                 <TotalPages> 1 </TotalPages>
  58                 <ChunkName > DatabaseTableId </ChunkName>
  59                 <TotalDataNodes> 0 </TotalDataNodes>
  60                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
  61                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  62         <Chunk Id> 11 </Chunk Id>
  63                 <TotalPages> 1 </TotalPages>
  64                 <ChunkName > UserTableId </ChunkName>
  65                 <TotalDataNodes> 2 </TotalDataNodes>
  66                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
  67                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  68         <Chunk Id> 12 </Chunk Id>
  69                 <TotalPages> 1 </TotalPages>
  70                 <ChunkName > TableTableId </ChunkName>
  71                 <TotalDataNodes> 1 </TotalDataNodes>
  72                 <SizeOfDataNodes> 92 </SizeOfDataNodes>
  73                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  74         <Chunk Id> 13 </Chunk Id>
  75                 <TotalPages> 1 </TotalPages>
  76                 <ChunkName > FieldTableId </ChunkName>
  77                 <TotalDataNodes> 2 </TotalDataNodes>
  78                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
  79                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  80         <Chunk Id> 14 </Chunk Id>
  81                 <TotalPages> 1 </TotalPages>
  82                 <ChunkName > AccessTableId </ChunkName>
  83                 <TotalDataNodes> 0 </TotalDataNodes>
  84                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
  85                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  86         <Chunk Id> 15 </Chunk Id>
  87                 <TotalPages> 1 </TotalPages>
  88                 <ChunkName > IndexTableId </ChunkName>
  89                 <TotalDataNodes> 1 </TotalDataNodes>
  90                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
  91                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  92         <Chunk Id> 16 </Chunk Id>
  93                 <TotalPages> 1 </TotalPages>
  94                 <ChunkName > IndexFieldTableId </ChunkName>
  95                 <TotalDataNodes> 1 </TotalDataNodes>
  96                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
  97                 <Allocation Type> FixedSizeAllocator </Allocation Type>
  98         <Chunk Id> 17 </Chunk Id>
  99                 <TotalPages> 1 </TotalPages>
 100                 <ChunkName > ForeignKeyTableId </ChunkName>
 101                 <TotalDataNodes> 0 </TotalDataNodes>
 102                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
 103                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 104         <Chunk Id> 18 </Chunk Id>
 105                 <TotalPages> 1 </TotalPages>
 106                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
 107                 <TotalDataNodes> 0 </TotalDataNodes>
 108                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 109                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 110   </System Chunk >
 111   <User Chunk >
 112         <Chunk Id> 101 </Chunk Id>
 113                 <TotalPages> 1 </TotalPages>
 114                 <ChunkName > t1 </ChunkName>
 115                 <TotalDataNodes> 5 </TotalDataNodes>
 116                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 117                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 118         <Chunk Id> 102 </Chunk Id>
 119                 <TotalPages> 1 </TotalPages>
 120                 <ChunkName > idx1 </ChunkName>
 121                 <TotalDataNodes> 1 </TotalDataNodes>
 122                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 123                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 124         <Chunk Id> 103 </Chunk Id>
 125                 <TotalPages> 1 </TotalPages>
 126                 <ChunkName > idx1 </ChunkName>
 127                 <TotalDataNodes> 5 </TotalDataNodes>
 128                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 129                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 130   </User Chunk >
 131 </Chunk information>
 132 echo SET AUTOCOMMIT OFF;
 133 AUTOCOMMIT Mode is set to OFF
 134 echo INSERT INTO t1 VALUES(6,60);
 135 Statement Executed: Rows Affected = 1
 136 echo INSERT INTO t1 VALUES(7,70);
 137 Statement Executed: Rows Affected = 1
 138 echo INSERT INTO t1 VALUES(8,80);
 139 Statement Executed: Rows Affected = 1
 140 echo INSERT INTO t1 VALUES(9,90);
 141 Statement Executed: Rows Affected = 1
 142 echo INSERT INTO t1 VALUES(10,100);
 143 Statement Executed: Rows Affected = 1
 144 echo ROLLBACK;
 145 <Chunk information>
 146   <System Chunk >
 147         <Chunk Id> 0 </Chunk Id>
 148                 <TotalPages> 1 </TotalPages>
 149                 <ChunkName > UserChunkTableId </ChunkName>
 150                 <TotalDataNodes> 3 </TotalDataNodes>
 151                 <SizeOfDataNodes> 112 </SizeOfDataNodes>
 152                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 153         <Chunk Id> 1 </Chunk Id>
 154                 <TotalPages> 1 </TotalPages>
 155                 <ChunkName > LockTableHashBucketId </ChunkName>
 156                 <TotalDataNodes> 1 </TotalDataNodes>
 157                 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
 158                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 159         <Chunk Id> 2 </Chunk Id>
 160                 <TotalPages> 1 </TotalPages>
 161                 <ChunkName > LockTableMutexId </ChunkName>
 162                 <TotalDataNodes> 0 </TotalDataNodes>
 163                 <SizeOfDataNodes> 49156 </SizeOfDataNodes>
 164                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 165         <Chunk Id> 3 </Chunk Id>
 166                 <TotalPages> 1 </TotalPages>
 167                 <ChunkName > LockTableId </ChunkName>
 168                 <TotalDataNodes> 0 </TotalDataNodes>
 169                 <SizeOfDataNodes> 24 </SizeOfDataNodes>
 170                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 171         <Chunk Id> 4 </Chunk Id>
 172                 <TotalPages> 1 </TotalPages>
 173                 <ChunkName > TransHasTableId </ChunkName>
 174                 <TotalDataNodes> 0 </TotalDataNodes>
 175                 <SizeOfDataNodes> 12 </SizeOfDataNodes>
 176                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 177         <Chunk Id> 5 </Chunk Id>
 178                 <TotalPages> 1 </TotalPages>
 179                 <ChunkName > UndoLogTableId </ChunkName>
 180                 <TotalDataNodes> 0 </TotalDataNodes>
 181                 <SizeOfDataNodes> 0 </SizeOfDataNodes>
 182                 <Allocation Type> VariableSizeAllocator </Allocation Type>
 183         <Chunk Id> 10 </Chunk Id>
 184                 <TotalPages> 1 </TotalPages>
 185                 <ChunkName > DatabaseTableId </ChunkName>
 186                 <TotalDataNodes> 0 </TotalDataNodes>
 187                 <SizeOfDataNodes> 84 </SizeOfDataNodes>
 188                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 189         <Chunk Id> 11 </Chunk Id>
 190                 <TotalPages> 1 </TotalPages>
 191                 <ChunkName > UserTableId </ChunkName>
 192                 <TotalDataNodes> 2 </TotalDataNodes>
 193                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 194                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 195         <Chunk Id> 12 </Chunk Id>
 196                 <TotalPages> 1 </TotalPages>
 197                 <ChunkName > TableTableId </ChunkName>
 198                 <TotalDataNodes> 1 </TotalDataNodes>
 199                 <SizeOfDataNodes> 92 </SizeOfDataNodes>
 200                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 201         <Chunk Id> 13 </Chunk Id>
 202                 <TotalPages> 1 </TotalPages>
 203                 <ChunkName > FieldTableId </ChunkName>
 204                 <TotalDataNodes> 2 </TotalDataNodes>
 205                 <SizeOfDataNodes> 144 </SizeOfDataNodes>
 206                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 207         <Chunk Id> 14 </Chunk Id>
 208                 <TotalPages> 1 </TotalPages>
 209                 <ChunkName > AccessTableId </ChunkName>
 210                 <TotalDataNodes> 0 </TotalDataNodes>
 211                 <SizeOfDataNodes> 132 </SizeOfDataNodes>
 212                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 213         <Chunk Id> 15 </Chunk Id>
 214                 <TotalPages> 1 </TotalPages>
 215                 <ChunkName > IndexTableId </ChunkName>
 216                 <TotalDataNodes> 1 </TotalDataNodes>
 217                 <SizeOfDataNodes> 104 </SizeOfDataNodes>
 218                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 219         <Chunk Id> 16 </Chunk Id>
 220                 <TotalPages> 1 </TotalPages>
 221                 <ChunkName > IndexFieldTableId </ChunkName>
 222                 <TotalDataNodes> 1 </TotalDataNodes>
 223                 <SizeOfDataNodes> 20 </SizeOfDataNodes>
 224                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 225         <Chunk Id> 17 </Chunk Id>
 226                 <TotalPages> 1 </TotalPages>
 227                 <ChunkName > ForeignKeyTableId </ChunkName>
 228                 <TotalDataNodes> 0 </TotalDataNodes>
 229                 <SizeOfDataNodes> 76 </SizeOfDataNodes>
 230                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 231         <Chunk Id> 18 </Chunk Id>
 232                 <TotalPages> 1 </TotalPages>
 233                 <ChunkName > ForeignKeyFieldTableId </ChunkName>
 234                 <TotalDataNodes> 0 </TotalDataNodes>
 235                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 236                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 237   </System Chunk >
 238   <User Chunk >
 239         <Chunk Id> 101 </Chunk Id>
 240                 <TotalPages> 1 </TotalPages>
 241                 <ChunkName > t1 </ChunkName>
 242                 <TotalDataNodes> 5 </TotalDataNodes>
 243                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 244                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 245         <Chunk Id> 102 </Chunk Id>
 246                 <TotalPages> 1 </TotalPages>
 247                 <ChunkName > idx1 </ChunkName>
 248                 <TotalDataNodes> 1 </TotalDataNodes>
 249                 <SizeOfDataNodes> 28256 </SizeOfDataNodes>
 250                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 251         <Chunk Id> 103 </Chunk Id>
 252                 <TotalPages> 1 </TotalPages>
 253                 <ChunkName > idx1 </ChunkName>
 254                 <TotalDataNodes> 5 </TotalDataNodes>
 255                 <SizeOfDataNodes> 16 </SizeOfDataNodes>
 256                 <Allocation Type> FixedSizeAllocator </Allocation Type>
 257   </User Chunk >
 258 </Chunk information>
 259 Statement Executed