exp.test005a

b树实现源码,linux和unix下运行,速度快,极好用

Table created
Index created for f1
Total Tuples inserted is 10
Total Tuples selected is 10
Before rollback
<LockTable>
<Lock Node>
  <Tuple> 17e82014 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 20 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82024 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 36 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82034 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 52 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82044 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 68 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82054 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 84 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82064 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 100 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82074 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 116 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82084 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 132 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e82094 </Tuple>
  <NoOfReaders> 1 </NoOfReaders>
  <WaitReaders> 0 </WaitReaders>
  <WaitWriters> 0 </WaitWriters>
</Lock Node>
  <LockBucket> 
    <BucketNo> 148 </BucketNo> 
    <TotalNodes> 1 </TotalNodes>
  <LockBucket>
<Lock Node>
  <Tuple> 17e820a4 </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