test/system/trans/exp.test003

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