test/system/trans/exp.test007a

   1 Table created
   2 Index created for f1
   3 Total Tuples inserted is 10
   4 Total Tuples updated is 10
   5 Before commit
   6 <TransactionTable>
   7 <TransactionInfo>
   8 <UndoLogs>
   9   <TotalPages> 1 </TotalPages>
  10 <UndoLogInfo>
  11   <Size> 32 </Size>
  12   <OperationType> 2 </OperationType>
  13   <TuplePtr> 17e7a0a4 </TuplePtr>
  14 </UndoLogInfo>
  15 <UndoLogInfo>
  16   <Size> 32 </Size>
  17   <OperationType> 2 </OperationType>
  18   <TuplePtr> 17e7a094 </TuplePtr>
  19 </UndoLogInfo>
  20 <UndoLogInfo>
  21   <Size> 32 </Size>
  22   <OperationType> 2 </OperationType>
  23   <TuplePtr> 17e7a084 </TuplePtr>
  24 </UndoLogInfo>
  25 <UndoLogInfo>
  26   <Size> 32 </Size>
  27   <OperationType> 2 </OperationType>
  28   <TuplePtr> 17e7a074 </TuplePtr>
  29 </UndoLogInfo>
  30 <UndoLogInfo>
  31   <Size> 32 </Size>
  32   <OperationType> 2 </OperationType>
  33   <TuplePtr> 17e7a064 </TuplePtr>
  34 </UndoLogInfo>
  35 <UndoLogInfo>
  36   <Size> 32 </Size>
  37   <OperationType> 2 </OperationType>
  38   <TuplePtr> 17e7a054 </TuplePtr>
  39 </UndoLogInfo>
  40 <UndoLogInfo>
  41   <Size> 32 </Size>
  42   <OperationType> 2 </OperationType>
  43   <TuplePtr> 17e7a044 </TuplePtr>
  44 </UndoLogInfo>
  45 <UndoLogInfo>
  46   <Size> 32 </Size>
  47   <OperationType> 2 </OperationType>
  48   <TuplePtr> 17e7a034 </TuplePtr>
  49 </UndoLogInfo>
  50 <UndoLogInfo>
  51   <Size> 32 </Size>
  52   <OperationType> 2 </OperationType>
  53   <TuplePtr> 17e7a024 </TuplePtr>
  54 </UndoLogInfo>
  55 <UndoLogInfo>
  56   <Size> 32 </Size>
  57   <OperationType> 2 </OperationType>
  58   <TuplePtr> 17e7a014 </TuplePtr>
  59 </UndoLogInfo>
  60 </TotalNodes> 10 </TotalNodes>
  61 </UndoLogs>
  62 <TransHasList>
  63   <TotalPages> 1 </TotalPages>
  64 <Lock Node>
  65   <Tuple> 17e7a014 </Tuple>
  66   <NoOfReaders> -1 </NoOfReaders>
  67   <WaitReaders> 0 </WaitReaders>
  68   <WaitWriters> 0 </WaitWriters>
  69 </Lock Node>
  70 <Lock Node>
  71   <Tuple> 17e7a024 </Tuple>
  72   <NoOfReaders> -1 </NoOfReaders>
  73   <WaitReaders> 0 </WaitReaders>
  74   <WaitWriters> 0 </WaitWriters>
  75 </Lock Node>
  76 <Lock Node>
  77   <Tuple> 17e7a034 </Tuple>
  78   <NoOfReaders> -1 </NoOfReaders>
  79   <WaitReaders> 0 </WaitReaders>
  80   <WaitWriters> 0 </WaitWriters>
  81 </Lock Node>
  82 <Lock Node>
  83   <Tuple> 17e7a044 </Tuple>
  84   <NoOfReaders> -1 </NoOfReaders>
  85   <WaitReaders> 0 </WaitReaders>
  86   <WaitWriters> 0 </WaitWriters>
  87 </Lock Node>
  88 <Lock Node>
  89   <Tuple> 17e7a054 </Tuple>
  90   <NoOfReaders> -1 </NoOfReaders>
  91   <WaitReaders> 0 </WaitReaders>
  92   <WaitWriters> 0 </WaitWriters>
  93 </Lock Node>
  94 <Lock Node>
  95   <Tuple> 17e7a064 </Tuple>
  96   <NoOfReaders> -1 </NoOfReaders>
  97   <WaitReaders> 0 </WaitReaders>
  98   <WaitWriters> 0 </WaitWriters>
  99 </Lock Node>
 100 <Lock Node>
 101   <Tuple> 17e7a074 </Tuple>
 102   <NoOfReaders> -1 </NoOfReaders>
 103   <WaitReaders> 0 </WaitReaders>
 104   <WaitWriters> 0 </WaitWriters>
 105 </Lock Node>
 106 <Lock Node>
 107   <Tuple> 17e7a084 </Tuple>
 108   <NoOfReaders> -1 </NoOfReaders>
 109   <WaitReaders> 0 </WaitReaders>
 110   <WaitWriters> 0 </WaitWriters>
 111 </Lock Node>
 112 <Lock Node>
 113   <Tuple> 17e7a094 </Tuple>
 114   <NoOfReaders> -1 </NoOfReaders>
 115   <WaitReaders> 0 </WaitReaders>
 116   <WaitWriters> 0 </WaitWriters>
 117 </Lock Node>
 118 <Lock Node>
 119   <Tuple> 17e7a0a4 </Tuple>
 120   <NoOfReaders> -1 </NoOfReaders>
 121   <WaitReaders> 0 </WaitReaders>
 122   <WaitWriters> 0 </WaitWriters>
 123 </Lock Node>
 124 </TotalNodes> 10 </TotalNodes>
 125 </TransHasList>
 126 </TransactionInfo>
 127   <UsedSlots> 1 </UsedSlots>
 128   <FreeSlots> 99 </FreeSlots>
 129   <UndoLogs>
 130     <TotalNodes> 10 </TotalNodes>
 131     <TotalPages> 1 </TotalPages>
 132   </UndoLogs>
 133 </TransactionTable>
 134 After commit
 135 <TransactionTable>
 136   <UsedSlots> 0 </UsedSlots>
 137   <FreeSlots> 100 </FreeSlots>
 138   <UndoLogs>
 139     <TotalNodes> 0 </TotalNodes>
 140     <TotalPages> 1 </TotalPages>
 141   </UndoLogs>
 142 </TransactionTable>
 143 Table Dropped