mysql for odbc
[csql.git] / test / system / trans / exp.test003a
blobeced5589e558cdc9b6d70ab0eacc27364a660340
1 Table created
2 Index created for f1
3 Total Tuples inserted is 10
4 Before commit
5 <TransactionTable>
6 <TransactionInfo>
7 <UndoLogs>
8   <TotalPages> 1 </TotalPages>
9 <UndoLogInfo>
10   <Size> 12 </Size>
11   <OperationType> 0 </OperationType>
12   <TuplePtr> 17e840a4 </TuplePtr>
13 </UndoLogInfo>
14 <UndoLogInfo>
15   <Size> 20 </Size>
16   <OperationType> 3 </OperationType>
17   <TuplePtr> 17e840a4 </TuplePtr>
18 </UndoLogInfo>
19 <UndoLogInfo>
20   <Size> 12 </Size>
21   <OperationType> 0 </OperationType>
22   <TuplePtr> 17e84094 </TuplePtr>
23 </UndoLogInfo>
24 <UndoLogInfo>
25   <Size> 20 </Size>
26   <OperationType> 3 </OperationType>
27   <TuplePtr> 17e84094 </TuplePtr>
28 </UndoLogInfo>
29 <UndoLogInfo>
30   <Size> 12 </Size>
31   <OperationType> 0 </OperationType>
32   <TuplePtr> 17e84084 </TuplePtr>
33 </UndoLogInfo>
34 <UndoLogInfo>
35   <Size> 20 </Size>
36   <OperationType> 3 </OperationType>
37   <TuplePtr> 17e84084 </TuplePtr>
38 </UndoLogInfo>
39 <UndoLogInfo>
40   <Size> 12 </Size>
41   <OperationType> 0 </OperationType>
42   <TuplePtr> 17e84074 </TuplePtr>
43 </UndoLogInfo>
44 <UndoLogInfo>
45   <Size> 20 </Size>
46   <OperationType> 3 </OperationType>
47   <TuplePtr> 17e84074 </TuplePtr>
48 </UndoLogInfo>
49 <UndoLogInfo>
50   <Size> 12 </Size>
51   <OperationType> 0 </OperationType>
52   <TuplePtr> 17e84064 </TuplePtr>
53 </UndoLogInfo>
54 <UndoLogInfo>
55   <Size> 20 </Size>
56   <OperationType> 3 </OperationType>
57   <TuplePtr> 17e84064 </TuplePtr>
58 </UndoLogInfo>
59 <UndoLogInfo>
60   <Size> 12 </Size>
61   <OperationType> 0 </OperationType>
62   <TuplePtr> 17e84054 </TuplePtr>
63 </UndoLogInfo>
64 <UndoLogInfo>
65   <Size> 20 </Size>
66   <OperationType> 3 </OperationType>
67   <TuplePtr> 17e84054 </TuplePtr>
68 </UndoLogInfo>
69 <UndoLogInfo>
70   <Size> 12 </Size>
71   <OperationType> 0 </OperationType>
72   <TuplePtr> 17e84044 </TuplePtr>
73 </UndoLogInfo>
74 <UndoLogInfo>
75   <Size> 20 </Size>
76   <OperationType> 3 </OperationType>
77   <TuplePtr> 17e84044 </TuplePtr>
78 </UndoLogInfo>
79 <UndoLogInfo>
80   <Size> 12 </Size>
81   <OperationType> 0 </OperationType>
82   <TuplePtr> 17e84034 </TuplePtr>
83 </UndoLogInfo>
84 <UndoLogInfo>
85   <Size> 20 </Size>
86   <OperationType> 3 </OperationType>
87   <TuplePtr> 17e84034 </TuplePtr>
88 </UndoLogInfo>
89 <UndoLogInfo>
90   <Size> 12 </Size>
91   <OperationType> 0 </OperationType>
92   <TuplePtr> 17e84024 </TuplePtr>
93 </UndoLogInfo>
94 <UndoLogInfo>
95   <Size> 20 </Size>
96   <OperationType> 3 </OperationType>
97   <TuplePtr> 17e84024 </TuplePtr>
98 </UndoLogInfo>
99 <UndoLogInfo>
100   <Size> 12 </Size>
101   <OperationType> 0 </OperationType>
102   <TuplePtr> 17e84014 </TuplePtr>
103 </UndoLogInfo>
104 <UndoLogInfo>
105   <Size> 20 </Size>
106   <OperationType> 3 </OperationType>
107   <TuplePtr> 17e84014 </TuplePtr>
108 </UndoLogInfo>
109 </TotalNodes> 20 </TotalNodes>
110 </UndoLogs>
111 <TransHasList>
112   <TotalPages> 1 </TotalPages>
113 <Lock Node>
114   <Tuple> 17e84014 </Tuple>
115   <NoOfReaders> -1 </NoOfReaders>
116   <WaitReaders> 0 </WaitReaders>
117   <WaitWriters> 0 </WaitWriters>
118 </Lock Node>
119 <Lock Node>
120   <Tuple> 17e84024 </Tuple>
121   <NoOfReaders> -1 </NoOfReaders>
122   <WaitReaders> 0 </WaitReaders>
123   <WaitWriters> 0 </WaitWriters>
124 </Lock Node>
125 <Lock Node>
126   <Tuple> 17e84034 </Tuple>
127   <NoOfReaders> -1 </NoOfReaders>
128   <WaitReaders> 0 </WaitReaders>
129   <WaitWriters> 0 </WaitWriters>
130 </Lock Node>
131 <Lock Node>
132   <Tuple> 17e84044 </Tuple>
133   <NoOfReaders> -1 </NoOfReaders>
134   <WaitReaders> 0 </WaitReaders>
135   <WaitWriters> 0 </WaitWriters>
136 </Lock Node>
137 <Lock Node>
138   <Tuple> 17e84054 </Tuple>
139   <NoOfReaders> -1 </NoOfReaders>
140   <WaitReaders> 0 </WaitReaders>
141   <WaitWriters> 0 </WaitWriters>
142 </Lock Node>
143 <Lock Node>
144   <Tuple> 17e84064 </Tuple>
145   <NoOfReaders> -1 </NoOfReaders>
146   <WaitReaders> 0 </WaitReaders>
147   <WaitWriters> 0 </WaitWriters>
148 </Lock Node>
149 <Lock Node>
150   <Tuple> 17e84074 </Tuple>
151   <NoOfReaders> -1 </NoOfReaders>
152   <WaitReaders> 0 </WaitReaders>
153   <WaitWriters> 0 </WaitWriters>
154 </Lock Node>
155 <Lock Node>
156   <Tuple> 17e84084 </Tuple>
157   <NoOfReaders> -1 </NoOfReaders>
158   <WaitReaders> 0 </WaitReaders>
159   <WaitWriters> 0 </WaitWriters>
160 </Lock Node>
161 <Lock Node>
162   <Tuple> 17e84094 </Tuple>
163   <NoOfReaders> -1 </NoOfReaders>
164   <WaitReaders> 0 </WaitReaders>
165   <WaitWriters> 0 </WaitWriters>
166 </Lock Node>
167 <Lock Node>
168   <Tuple> 17e840a4 </Tuple>
169   <NoOfReaders> -1 </NoOfReaders>
170   <WaitReaders> 0 </WaitReaders>
171   <WaitWriters> 0 </WaitWriters>
172 </Lock Node>
173 </TotalNodes> 10 </TotalNodes>
174 </TransHasList>
175 </TransactionInfo>
176   <UsedSlots> 1 </UsedSlots>
177   <FreeSlots> 99 </FreeSlots>
178   <UndoLogs>
179     <TotalNodes> 20 </TotalNodes>
180     <TotalPages> 1 </TotalPages>
181   </UndoLogs>
182 </TransactionTable>
183 After commit
184 <TransactionTable>
185   <UsedSlots> 0 </UsedSlots>
186   <FreeSlots> 100 </FreeSlots>
187   <UndoLogs>
188     <TotalNodes> 0 </TotalNodes>
189     <TotalPages> 1 </TotalPages>
190   </UndoLogs>
191 </TransactionTable>
192 Table Dropped