test/system/trans/exp.test007

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