*** empty log message ***
[csql.git] / test / system / trans / exp.test008a
blobfbea281b83d96eea8a7dfb2c244480afa133ed1a
1 Table created
2 Index created for f1
3 Total Tuples inserted is 10
4 Total Tuples updated is 10
5 Before abort
6 <TransactionTable>
7 <TransactionInfo>
8 <UndoLogs>
9   <TotalPages> 1 </TotalPages>
10 <UndoLogInfo>
11   <Size> 32 </Size>
12   <OperationType> 2 </OperationType>
13   <TuplePtr> 17e7a0a4 </TuplePtr>
14 </UndoLogInfo>
15 <UndoLogInfo>
16   <Size> 32 </Size>
17   <OperationType> 2 </OperationType>
18   <TuplePtr> 17e7a094 </TuplePtr>
19 </UndoLogInfo>
20 <UndoLogInfo>
21   <Size> 32 </Size>
22   <OperationType> 2 </OperationType>
23   <TuplePtr> 17e7a084 </TuplePtr>
24 </UndoLogInfo>
25 <UndoLogInfo>
26   <Size> 32 </Size>
27   <OperationType> 2 </OperationType>
28   <TuplePtr> 17e7a074 </TuplePtr>
29 </UndoLogInfo>
30 <UndoLogInfo>
31   <Size> 32 </Size>
32   <OperationType> 2 </OperationType>
33   <TuplePtr> 17e7a064 </TuplePtr>
34 </UndoLogInfo>
35 <UndoLogInfo>
36   <Size> 32 </Size>
37   <OperationType> 2 </OperationType>
38   <TuplePtr> 17e7a054 </TuplePtr>
39 </UndoLogInfo>
40 <UndoLogInfo>
41   <Size> 32 </Size>
42   <OperationType> 2 </OperationType>
43   <TuplePtr> 17e7a044 </TuplePtr>
44 </UndoLogInfo>
45 <UndoLogInfo>
46   <Size> 32 </Size>
47   <OperationType> 2 </OperationType>
48   <TuplePtr> 17e7a034 </TuplePtr>
49 </UndoLogInfo>
50 <UndoLogInfo>
51   <Size> 32 </Size>
52   <OperationType> 2 </OperationType>
53   <TuplePtr> 17e7a024 </TuplePtr>
54 </UndoLogInfo>
55 <UndoLogInfo>
56   <Size> 32 </Size>
57   <OperationType> 2 </OperationType>
58   <TuplePtr> 17e7a014 </TuplePtr>
59 </UndoLogInfo>
60 </TotalNodes> 10 </TotalNodes>
61 </UndoLogs>
62 <TransHasList>
63   <TotalPages> 1 </TotalPages>
64 <Lock Node>
65   <Tuple> 17e7a014 </Tuple>
66   <NoOfReaders> -1 </NoOfReaders>
67   <WaitReaders> 0 </WaitReaders>
68   <WaitWriters> 0 </WaitWriters>
69 </Lock Node>
70 <Lock Node>
71   <Tuple> 17e7a024 </Tuple>
72   <NoOfReaders> -1 </NoOfReaders>
73   <WaitReaders> 0 </WaitReaders>
74   <WaitWriters> 0 </WaitWriters>
75 </Lock Node>
76 <Lock Node>
77   <Tuple> 17e7a034 </Tuple>
78   <NoOfReaders> -1 </NoOfReaders>
79   <WaitReaders> 0 </WaitReaders>
80   <WaitWriters> 0 </WaitWriters>
81 </Lock Node>
82 <Lock Node>
83   <Tuple> 17e7a044 </Tuple>
84   <NoOfReaders> -1 </NoOfReaders>
85   <WaitReaders> 0 </WaitReaders>
86   <WaitWriters> 0 </WaitWriters>
87 </Lock Node>
88 <Lock Node>
89   <Tuple> 17e7a054 </Tuple>
90   <NoOfReaders> -1 </NoOfReaders>
91   <WaitReaders> 0 </WaitReaders>
92   <WaitWriters> 0 </WaitWriters>
93 </Lock Node>
94 <Lock Node>
95   <Tuple> 17e7a064 </Tuple>
96   <NoOfReaders> -1 </NoOfReaders>
97   <WaitReaders> 0 </WaitReaders>
98   <WaitWriters> 0 </WaitWriters>
99 </Lock Node>
100 <Lock Node>
101   <Tuple> 17e7a074 </Tuple>
102   <NoOfReaders> -1 </NoOfReaders>
103   <WaitReaders> 0 </WaitReaders>
104   <WaitWriters> 0 </WaitWriters>
105 </Lock Node>
106 <Lock Node>
107   <Tuple> 17e7a084 </Tuple>
108   <NoOfReaders> -1 </NoOfReaders>
109   <WaitReaders> 0 </WaitReaders>
110   <WaitWriters> 0 </WaitWriters>
111 </Lock Node>
112 <Lock Node>
113   <Tuple> 17e7a094 </Tuple>
114   <NoOfReaders> -1 </NoOfReaders>
115   <WaitReaders> 0 </WaitReaders>
116   <WaitWriters> 0 </WaitWriters>
117 </Lock Node>
118 <Lock Node>
119   <Tuple> 17e7a0a4 </Tuple>
120   <NoOfReaders> -1 </NoOfReaders>
121   <WaitReaders> 0 </WaitReaders>
122   <WaitWriters> 0 </WaitWriters>
123 </Lock Node>
124 </TotalNodes> 10 </TotalNodes>
125 </TransHasList>
126 </TransactionInfo>
127   <UsedSlots> 1 </UsedSlots>
128   <FreeSlots> 99 </FreeSlots>
129   <UndoLogs>
130     <TotalNodes> 10 </TotalNodes>
131     <TotalPages> 1 </TotalPages>
132   </UndoLogs>
133 </TransactionTable>
134 After abort
135 <TransactionTable>
136   <UsedSlots> 0 </UsedSlots>
137   <FreeSlots> 100 </FreeSlots>
138   <UndoLogs>
139     <TotalNodes> 0 </TotalNodes>
140     <TotalPages> 1 </TotalPages>
141   </UndoLogs>
142 </TransactionTable>
143 Table Dropped