This has following fixes.
[csql.git] / test / system / lock / exp.test002
blob8dad753100c9fdfd8f7702ce855c5e8df51839e3
1 Table created
2 Total Tuples inserted is 10
3 Before rollback
4 <LockTable>
5 <Lock Node>
6   <Tuple> 17e7a014 </Tuple>
7   <NoOfReaders> -1 </NoOfReaders>
8   <WaitReaders> 0 </WaitReaders>
9   <WaitWriters> 0 </WaitWriters>
10 </Lock Node>
11   <LockBucket> 
12     <BucketNo> 20 </BucketNo> 
13     <TotalNodes> 1 </TotalNodes>
14   <LockBucket>
15 <Lock Node>
16   <Tuple> 17e7a024 </Tuple>
17   <NoOfReaders> -1 </NoOfReaders>
18   <WaitReaders> 0 </WaitReaders>
19   <WaitWriters> 0 </WaitWriters>
20 </Lock Node>
21   <LockBucket> 
22     <BucketNo> 36 </BucketNo> 
23     <TotalNodes> 1 </TotalNodes>
24   <LockBucket>
25 <Lock Node>
26   <Tuple> 17e7a034 </Tuple>
27   <NoOfReaders> -1 </NoOfReaders>
28   <WaitReaders> 0 </WaitReaders>
29   <WaitWriters> 0 </WaitWriters>
30 </Lock Node>
31   <LockBucket> 
32     <BucketNo> 52 </BucketNo> 
33     <TotalNodes> 1 </TotalNodes>
34   <LockBucket>
35 <Lock Node>
36   <Tuple> 17e7a044 </Tuple>
37   <NoOfReaders> -1 </NoOfReaders>
38   <WaitReaders> 0 </WaitReaders>
39   <WaitWriters> 0 </WaitWriters>
40 </Lock Node>
41   <LockBucket> 
42     <BucketNo> 68 </BucketNo> 
43     <TotalNodes> 1 </TotalNodes>
44   <LockBucket>
45 <Lock Node>
46   <Tuple> 17e7a054 </Tuple>
47   <NoOfReaders> -1 </NoOfReaders>
48   <WaitReaders> 0 </WaitReaders>
49   <WaitWriters> 0 </WaitWriters>
50 </Lock Node>
51   <LockBucket> 
52     <BucketNo> 84 </BucketNo> 
53     <TotalNodes> 1 </TotalNodes>
54   <LockBucket>
55 <Lock Node>
56   <Tuple> 17e7a064 </Tuple>
57   <NoOfReaders> -1 </NoOfReaders>
58   <WaitReaders> 0 </WaitReaders>
59   <WaitWriters> 0 </WaitWriters>
60 </Lock Node>
61   <LockBucket> 
62     <BucketNo> 100 </BucketNo> 
63     <TotalNodes> 1 </TotalNodes>
64   <LockBucket>
65 <Lock Node>
66   <Tuple> 17e7a074 </Tuple>
67   <NoOfReaders> -1 </NoOfReaders>
68   <WaitReaders> 0 </WaitReaders>
69   <WaitWriters> 0 </WaitWriters>
70 </Lock Node>
71   <LockBucket> 
72     <BucketNo> 116 </BucketNo> 
73     <TotalNodes> 1 </TotalNodes>
74   <LockBucket>
75 <Lock Node>
76   <Tuple> 17e7a084 </Tuple>
77   <NoOfReaders> -1 </NoOfReaders>
78   <WaitReaders> 0 </WaitReaders>
79   <WaitWriters> 0 </WaitWriters>
80 </Lock Node>
81   <LockBucket> 
82     <BucketNo> 132 </BucketNo> 
83     <TotalNodes> 1 </TotalNodes>
84   <LockBucket>
85 <Lock Node>
86   <Tuple> 17e7a094 </Tuple>
87   <NoOfReaders> -1 </NoOfReaders>
88   <WaitReaders> 0 </WaitReaders>
89   <WaitWriters> 0 </WaitWriters>
90 </Lock Node>
91   <LockBucket> 
92     <BucketNo> 148 </BucketNo> 
93     <TotalNodes> 1 </TotalNodes>
94   <LockBucket>
95 <Lock Node>
96   <Tuple> 17e7a0a4 </Tuple>
97   <NoOfReaders> -1 </NoOfReaders>
98   <WaitReaders> 0 </WaitReaders>
99   <WaitWriters> 0 </WaitWriters>
100 </Lock Node>
101   <LockBucket> 
102     <BucketNo> 164 </BucketNo> 
103     <TotalNodes> 1 </TotalNodes>
104   <LockBucket>
105   <TotalUsedBuckets> 10 </TotalUsedBuckets>
106   <TotalPages> 1 </TotalPages>
107 </LockTable>
108 After rollback
109 <LockTable>
110   <TotalUsedBuckets> 0 </TotalUsedBuckets>
111   <TotalPages> 1 </TotalPages>
112 </LockTable>
113 Table Dropped