exp.test003

来自「b树实现源码,linux和unix下运行,速度快,极好用」· TEST003 代码 · 共 142 行

Table created
Total Tuples inserted is 10
Before commit
<TransactionTable>
<TransactionInfo>
<UndoLogs>
  <TotalPages> 1 </TotalPages>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e840a4 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84094 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84084 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84074 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84064 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84054 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84044 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84034 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84024 </TuplePtr>
</UndoLogInfo>
<UndoLogInfo>
  <Size> 12 </Size>
  <OperationType> 0 </OperationType>
  <TuplePtr> 17e84014 </TuplePtr>
</UndoLogInfo>
</TotalNodes> 10 </TotalNodes>
</UndoLogs>
<TransHasList>
  <TotalPages> 1 </TotalPages>
<Lock Node>
  <Tuple> 17e84014 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84024 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84034 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84044 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84054 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84064 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84074 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84084 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e84094 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
<Lock Node>
  <Tuple> 17e840a4 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
</TotalNodes> 10 </TotalNodes>
</TransHasList>
</TransactionInfo>
  <UsedSlots> 1 </UsedSlots>
  <FreeSlots> 99 </FreeSlots>
  <UndoLogs>
    <TotalNodes> 10 </TotalNodes>
    <TotalPages> 1 </TotalPages>
  </UndoLogs>
</TransactionTable>
After commit
<TransactionTable>
  <UsedSlots> 0 </UsedSlots>
  <FreeSlots> 100 </FreeSlots>
  <UndoLogs>
    <TotalNodes> 0 </TotalNodes>
    <TotalPages> 1 </TotalPages>
  </UndoLogs>
</TransactionTable>
Table Dropped