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