exp.test002

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

Table created
Total Tuples inserted is 10
Before rollback
<LockTable>
<Lock Node>
  <Tuple> 17e84014 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 20 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84024 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 36 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84034 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 52 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84044 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 68 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84054 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 84 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84064 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 100 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84074 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 116 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84084 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 132 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e84094 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 148 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e840a4 </Tuple>
  <NoOfReaders> -1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 164 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
  <TotalUsedBuckets> 10 </TotalUsedBuckets>
  <TotalPages> 1 </TotalPages>
</LockTable>
After rollback
<LockTable>
  <TotalUsedBuckets> 0 </TotalUsedBuckets>
  <TotalPages> 1 </TotalPages>
</LockTable>
Table Dropped