*** empty log message ***
[csql.git] / test / tools / csql / exp.test131.ksh
blobce5e70f31a7cd04cd92b9eea11d3e6cb362f7d4b
1 echo CREATE TABLE t1(f1 int,f2 int);
2 Statement Executed
3 echo CREATE INDEX idx1 on t1(f1);
4 Statement Executed
5 echo SET AUTOCOMMIT OFF;
6 AUTOCOMMIT Mode is set to OFF
7 echo INSERT INTO t1 VALUES(1,10);
8 Statement Executed: Rows Affected = 1
9 echo INSERT INTO t1 VALUES(2,20);
10 Statement Executed: Rows Affected = 1
11 echo INSERT INTO t1 VALUES(3,30);
12 Statement Executed: Rows Affected = 1
13 echo INSERT INTO t1 VALUES(4,40);
14 Statement Executed: Rows Affected = 1
15 echo INSERT INTO t1 VALUES(5,50);
16 Statement Executed: Rows Affected = 1
17 echo COMMIT;
18 <Chunk information>
19 <System Chunk >
20 <Chunk Id> 0 </Chunk Id>
21 <TotalPages> 1 </TotalPages>
22 <ChunkName > UserChunkTableId </ChunkName>
23 <TotalDataNodes> 3 </TotalDataNodes>
24 <SizeOfDataNodes> 116 </SizeOfDataNodes>
25 <Allocation Type> FixedSizeAllocator </Allocation Type>
26 <Chunk Id> 1 </Chunk Id>
27 <TotalPages> 1 </TotalPages>
28 <ChunkName > LockTableHashBucketId </ChunkName>
29 <TotalDataNodes> 1 </TotalDataNodes>
30 <SizeOfDataNodes> 65540 </SizeOfDataNodes>
31 <Allocation Type> FixedSizeAllocator </Allocation Type>
32 <Chunk Id> 2 </Chunk Id>
33 <TotalPages> 1 </TotalPages>
34 <ChunkName > LockTableMutexId </ChunkName>
35 <TotalDataNodes> 0 </TotalDataNodes>
36 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
37 <Allocation Type> FixedSizeAllocator </Allocation Type>
38 <Chunk Id> 3 </Chunk Id>
39 <TotalPages> 1 </TotalPages>
40 <ChunkName > LockTableId </ChunkName>
41 <TotalDataNodes> 0 </TotalDataNodes>
42 <SizeOfDataNodes> 24 </SizeOfDataNodes>
43 <Allocation Type> FixedSizeAllocator </Allocation Type>
44 <Chunk Id> 4 </Chunk Id>
45 <TotalPages> 1 </TotalPages>
46 <ChunkName > TransHasTableId </ChunkName>
47 <TotalDataNodes> 0 </TotalDataNodes>
48 <SizeOfDataNodes> 12 </SizeOfDataNodes>
49 <Allocation Type> FixedSizeAllocator </Allocation Type>
50 <Chunk Id> 5 </Chunk Id>
51 <TotalPages> 1 </TotalPages>
52 <ChunkName > UndoLogTableId </ChunkName>
53 <TotalDataNodes> 0 </TotalDataNodes>
54 <SizeOfDataNodes> 0 </SizeOfDataNodes>
55 <Allocation Type> VariableSizeAllocator </Allocation Type>
56 <Chunk Id> 10 </Chunk Id>
57 <TotalPages> 1 </TotalPages>
58 <ChunkName > DatabaseTableId </ChunkName>
59 <TotalDataNodes> 0 </TotalDataNodes>
60 <SizeOfDataNodes> 84 </SizeOfDataNodes>
61 <Allocation Type> FixedSizeAllocator </Allocation Type>
62 <Chunk Id> 11 </Chunk Id>
63 <TotalPages> 1 </TotalPages>
64 <ChunkName > UserTableId </ChunkName>
65 <TotalDataNodes> 2 </TotalDataNodes>
66 <SizeOfDataNodes> 132 </SizeOfDataNodes>
67 <Allocation Type> FixedSizeAllocator </Allocation Type>
68 <Chunk Id> 12 </Chunk Id>
69 <TotalPages> 1 </TotalPages>
70 <ChunkName > TableTableId </ChunkName>
71 <TotalDataNodes> 1 </TotalDataNodes>
72 <SizeOfDataNodes> 92 </SizeOfDataNodes>
73 <Allocation Type> FixedSizeAllocator </Allocation Type>
74 <Chunk Id> 13 </Chunk Id>
75 <TotalPages> 1 </TotalPages>
76 <ChunkName > FieldTableId </ChunkName>
77 <TotalDataNodes> 2 </TotalDataNodes>
78 <SizeOfDataNodes> 144 </SizeOfDataNodes>
79 <Allocation Type> FixedSizeAllocator </Allocation Type>
80 <Chunk Id> 14 </Chunk Id>
81 <TotalPages> 1 </TotalPages>
82 <ChunkName > AccessTableId </ChunkName>
83 <TotalDataNodes> 0 </TotalDataNodes>
84 <SizeOfDataNodes> 132 </SizeOfDataNodes>
85 <Allocation Type> FixedSizeAllocator </Allocation Type>
86 <Chunk Id> 15 </Chunk Id>
87 <TotalPages> 1 </TotalPages>
88 <ChunkName > IndexTableId </ChunkName>
89 <TotalDataNodes> 1 </TotalDataNodes>
90 <SizeOfDataNodes> 104 </SizeOfDataNodes>
91 <Allocation Type> FixedSizeAllocator </Allocation Type>
92 <Chunk Id> 16 </Chunk Id>
93 <TotalPages> 1 </TotalPages>
94 <ChunkName > IndexFieldTableId </ChunkName>
95 <TotalDataNodes> 1 </TotalDataNodes>
96 <SizeOfDataNodes> 20 </SizeOfDataNodes>
97 <Allocation Type> FixedSizeAllocator </Allocation Type>
98 <Chunk Id> 17 </Chunk Id>
99 <TotalPages> 1 </TotalPages>
100 <ChunkName > ForeignKeyTableId </ChunkName>
101 <TotalDataNodes> 0 </TotalDataNodes>
102 <SizeOfDataNodes> 76 </SizeOfDataNodes>
103 <Allocation Type> FixedSizeAllocator </Allocation Type>
104 <Chunk Id> 18 </Chunk Id>
105 <TotalPages> 1 </TotalPages>
106 <ChunkName > ForeignKeyFieldTableId </ChunkName>
107 <TotalDataNodes> 0 </TotalDataNodes>
108 <SizeOfDataNodes> 16 </SizeOfDataNodes>
109 <Allocation Type> FixedSizeAllocator </Allocation Type>
110 </System Chunk >
111 <User Chunk >
112 <Chunk Id> 101 </Chunk Id>
113 <TotalPages> 1 </TotalPages>
114 <ChunkName > t1 </ChunkName>
115 <TotalDataNodes> 5 </TotalDataNodes>
116 <SizeOfDataNodes> 16 </SizeOfDataNodes>
117 <Allocation Type> FixedSizeAllocator </Allocation Type>
118 <Chunk Id> 102 </Chunk Id>
119 <TotalPages> 1 </TotalPages>
120 <ChunkName > idx1 </ChunkName>
121 <TotalDataNodes> 1 </TotalDataNodes>
122 <SizeOfDataNodes> 32292 </SizeOfDataNodes>
123 <Allocation Type> FixedSizeAllocator </Allocation Type>
124 <Chunk Id> 103 </Chunk Id>
125 <TotalPages> 1 </TotalPages>
126 <ChunkName > idx1 </ChunkName>
127 <TotalDataNodes> 5 </TotalDataNodes>
128 <SizeOfDataNodes> 16 </SizeOfDataNodes>
129 <Allocation Type> FixedSizeAllocator </Allocation Type>
130 </User Chunk >
131 </Chunk information>
132 echo SET AUTOCOMMIT OFF;
133 AUTOCOMMIT Mode is set to OFF
134 echo INSERT INTO t1 VALUES(6,60);
135 Statement Executed: Rows Affected = 1
136 echo INSERT INTO t1 VALUES(7,70);
137 Statement Executed: Rows Affected = 1
138 echo INSERT INTO t1 VALUES(8,80);
139 Statement Executed: Rows Affected = 1
140 echo INSERT INTO t1 VALUES(9,90);
141 Statement Executed: Rows Affected = 1
142 echo INSERT INTO t1 VALUES(10,100);
143 Statement Executed: Rows Affected = 1
144 echo ROLLBACK;
145 <Chunk information>
146 <System Chunk >
147 <Chunk Id> 0 </Chunk Id>
148 <TotalPages> 1 </TotalPages>
149 <ChunkName > UserChunkTableId </ChunkName>
150 <TotalDataNodes> 3 </TotalDataNodes>
151 <SizeOfDataNodes> 116 </SizeOfDataNodes>
152 <Allocation Type> FixedSizeAllocator </Allocation Type>
153 <Chunk Id> 1 </Chunk Id>
154 <TotalPages> 1 </TotalPages>
155 <ChunkName > LockTableHashBucketId </ChunkName>
156 <TotalDataNodes> 1 </TotalDataNodes>
157 <SizeOfDataNodes> 65540 </SizeOfDataNodes>
158 <Allocation Type> FixedSizeAllocator </Allocation Type>
159 <Chunk Id> 2 </Chunk Id>
160 <TotalPages> 1 </TotalPages>
161 <ChunkName > LockTableMutexId </ChunkName>
162 <TotalDataNodes> 0 </TotalDataNodes>
163 <SizeOfDataNodes> 57348 </SizeOfDataNodes>
164 <Allocation Type> FixedSizeAllocator </Allocation Type>
165 <Chunk Id> 3 </Chunk Id>
166 <TotalPages> 1 </TotalPages>
167 <ChunkName > LockTableId </ChunkName>
168 <TotalDataNodes> 0 </TotalDataNodes>
169 <SizeOfDataNodes> 24 </SizeOfDataNodes>
170 <Allocation Type> FixedSizeAllocator </Allocation Type>
171 <Chunk Id> 4 </Chunk Id>
172 <TotalPages> 1 </TotalPages>
173 <ChunkName > TransHasTableId </ChunkName>
174 <TotalDataNodes> 0 </TotalDataNodes>
175 <SizeOfDataNodes> 12 </SizeOfDataNodes>
176 <Allocation Type> FixedSizeAllocator </Allocation Type>
177 <Chunk Id> 5 </Chunk Id>
178 <TotalPages> 1 </TotalPages>
179 <ChunkName > UndoLogTableId </ChunkName>
180 <TotalDataNodes> 0 </TotalDataNodes>
181 <SizeOfDataNodes> 0 </SizeOfDataNodes>
182 <Allocation Type> VariableSizeAllocator </Allocation Type>
183 <Chunk Id> 10 </Chunk Id>
184 <TotalPages> 1 </TotalPages>
185 <ChunkName > DatabaseTableId </ChunkName>
186 <TotalDataNodes> 0 </TotalDataNodes>
187 <SizeOfDataNodes> 84 </SizeOfDataNodes>
188 <Allocation Type> FixedSizeAllocator </Allocation Type>
189 <Chunk Id> 11 </Chunk Id>
190 <TotalPages> 1 </TotalPages>
191 <ChunkName > UserTableId </ChunkName>
192 <TotalDataNodes> 2 </TotalDataNodes>
193 <SizeOfDataNodes> 132 </SizeOfDataNodes>
194 <Allocation Type> FixedSizeAllocator </Allocation Type>
195 <Chunk Id> 12 </Chunk Id>
196 <TotalPages> 1 </TotalPages>
197 <ChunkName > TableTableId </ChunkName>
198 <TotalDataNodes> 1 </TotalDataNodes>
199 <SizeOfDataNodes> 92 </SizeOfDataNodes>
200 <Allocation Type> FixedSizeAllocator </Allocation Type>
201 <Chunk Id> 13 </Chunk Id>
202 <TotalPages> 1 </TotalPages>
203 <ChunkName > FieldTableId </ChunkName>
204 <TotalDataNodes> 2 </TotalDataNodes>
205 <SizeOfDataNodes> 144 </SizeOfDataNodes>
206 <Allocation Type> FixedSizeAllocator </Allocation Type>
207 <Chunk Id> 14 </Chunk Id>
208 <TotalPages> 1 </TotalPages>
209 <ChunkName > AccessTableId </ChunkName>
210 <TotalDataNodes> 0 </TotalDataNodes>
211 <SizeOfDataNodes> 132 </SizeOfDataNodes>
212 <Allocation Type> FixedSizeAllocator </Allocation Type>
213 <Chunk Id> 15 </Chunk Id>
214 <TotalPages> 1 </TotalPages>
215 <ChunkName > IndexTableId </ChunkName>
216 <TotalDataNodes> 1 </TotalDataNodes>
217 <SizeOfDataNodes> 104 </SizeOfDataNodes>
218 <Allocation Type> FixedSizeAllocator </Allocation Type>
219 <Chunk Id> 16 </Chunk Id>
220 <TotalPages> 1 </TotalPages>
221 <ChunkName > IndexFieldTableId </ChunkName>
222 <TotalDataNodes> 1 </TotalDataNodes>
223 <SizeOfDataNodes> 20 </SizeOfDataNodes>
224 <Allocation Type> FixedSizeAllocator </Allocation Type>
225 <Chunk Id> 17 </Chunk Id>
226 <TotalPages> 1 </TotalPages>
227 <ChunkName > ForeignKeyTableId </ChunkName>
228 <TotalDataNodes> 0 </TotalDataNodes>
229 <SizeOfDataNodes> 76 </SizeOfDataNodes>
230 <Allocation Type> FixedSizeAllocator </Allocation Type>
231 <Chunk Id> 18 </Chunk Id>
232 <TotalPages> 1 </TotalPages>
233 <ChunkName > ForeignKeyFieldTableId </ChunkName>
234 <TotalDataNodes> 0 </TotalDataNodes>
235 <SizeOfDataNodes> 16 </SizeOfDataNodes>
236 <Allocation Type> FixedSizeAllocator </Allocation Type>
237 </System Chunk >
238 <User Chunk >
239 <Chunk Id> 101 </Chunk Id>
240 <TotalPages> 1 </TotalPages>
241 <ChunkName > t1 </ChunkName>
242 <TotalDataNodes> 5 </TotalDataNodes>
243 <SizeOfDataNodes> 16 </SizeOfDataNodes>
244 <Allocation Type> FixedSizeAllocator </Allocation Type>
245 <Chunk Id> 102 </Chunk Id>
246 <TotalPages> 1 </TotalPages>
247 <ChunkName > idx1 </ChunkName>
248 <TotalDataNodes> 1 </TotalDataNodes>
249 <SizeOfDataNodes> 32292 </SizeOfDataNodes>
250 <Allocation Type> FixedSizeAllocator </Allocation Type>
251 <Chunk Id> 103 </Chunk Id>
252 <TotalPages> 1 </TotalPages>
253 <ChunkName > idx1 </ChunkName>
254 <TotalDataNodes> 5 </TotalDataNodes>
255 <SizeOfDataNodes> 16 </SizeOfDataNodes>
256 <Allocation Type> FixedSizeAllocator </Allocation Type>
257 </User Chunk >
258 </Chunk information>
259 Statement Executed