adding test scripts
[csql.git] / test / sqlapi / Csql / DDLStmt / exp.test009.ksh
blob0d6018fa0caead80d146e063813945eb0775a9c0
1 Connection opened
2 Table t1 Created
3 Index Created
4 Index Created
5 Index Created
6 Index Created
7 Index Created
8 Index Created
9 Index Created
10 Index Already Exist
11 Index Created
12 Index Created
13 Index Created
14 Index Created
15 Index Created
16 Index Created
17 Index Already Exist
18 Index Already Exist
19 Index Created
20 Index Created
21 Index Created
22 Index Created
23 Index Created
24 Index Already Exist
25 Index Already Exist
26 Index Already Exist
27 Index Created
28 Index Created
29 Index Created
30 Index Created
31 Index Already Exist
32 Index Already Exist
33 Index Already Exist
34 Index Already Exist
35 Index Created
36 Index Created
37 Index Created
38 Index Already Exist
39 Index Already Exist
40 Index Already Exist
41 Index Already Exist
42 Index Already Exist
43 Index Created
44 Index Created
45 Index Already Exist
46 Index Already Exist
47 Index Already Exist
48 Index Already Exist
49 Index Already Exist
50 Index Already Exist
51 Index Created
52 Index Already Exist
53 Index Already Exist
54 Index Already Exist
55 Index Already Exist
56 Index Already Exist
57 Index Already Exist
58 Index Already Exist
59 Index Created
60 Index Created
61 Index Created
62 Index Created
63 Index Created
64 Index Created
65 TABLES
66 --------
68 Connection Closed
69 <Table Information of all tables>
70 <TableInfo>
71 <TableName> t1 </TableName>
72 <FieldInfo>
73 <FieldName> f1 </FieldName>
74 <Type> 4 </Type>
75 <Length> 4 </Length>
76 <Primary> 0 </Primary>
77 <Null> 0 </Null>
78 <Default> 0 </Default>
79 <DefaultValue> </DefaultValue>
80 </FieldInfo>
81 <FieldInfo>
82 <FieldName> f2 </FieldName>
83 <Type> 3 </Type>
84 <Length> 4 </Length>
85 <Primary> 0 </Primary>
86 <Null> 0 </Null>
87 <Default> 0 </Default>
88 <DefaultValue> </DefaultValue>
89 </FieldInfo>
90 <FieldInfo>
91 <FieldName> f3 </FieldName>
92 <Type> 0 </Type>
93 <Length> 4 </Length>
94 <Primary> 0 </Primary>
95 <Null> 0 </Null>
96 <Default> 0 </Default>
97 <DefaultValue> </DefaultValue>
98 </FieldInfo>
99 <FieldInfo>
100 <FieldName> f4 </FieldName>
101 <Type> 2 </Type>
102 <Length> 8 </Length>
103 <Primary> 0 </Primary>
104 <Null> 0 </Null>
105 <Default> 0 </Default>
106 <DefaultValue> </DefaultValue>
107 </FieldInfo>
108 <FieldInfo>
109 <FieldName> f5 </FieldName>
110 <Type> 30 </Type>
111 <Length> 20 </Length>
112 <Primary> 0 </Primary>
113 <Null> 0 </Null>
114 <Default> 0 </Default>
115 <DefaultValue> </DefaultValue>
116 </FieldInfo>
117 <FieldInfo>
118 <FieldName> f6 </FieldName>
119 <Type> 32 </Type>
120 <Length> 32 </Length>
121 <Primary> 0 </Primary>
122 <Null> 0 </Null>
123 <Default> 0 </Default>
124 <DefaultValue> </DefaultValue>
125 </FieldInfo>
126 <FieldInfo>
127 <FieldName> f7 </FieldName>
128 <Type> 11 </Type>
129 <Length> 4 </Length>
130 <Primary> 0 </Primary>
131 <Null> 0 </Null>
132 <Default> 0 </Default>
133 <DefaultValue> </DefaultValue>
134 </FieldInfo>
135 <FieldInfo>
136 <FieldName> f8 </FieldName>
137 <Type> 10 </Type>
138 <Length> 8 </Length>
139 <Primary> 0 </Primary>
140 <Null> 0 </Null>
141 <Default> 0 </Default>
142 <DefaultValue> </DefaultValue>
143 </FieldInfo>
144 <FieldInfo>
145 <FieldName> f9 </FieldName>
146 <Type> 20 </Type>
147 <Length> 4 </Length>
148 <Primary> 0 </Primary>
149 <Null> 0 </Null>
150 <Default> 0 </Default>
151 <DefaultValue> </DefaultValue>
152 </FieldInfo>
153 <FieldInfo>
154 <FieldName> f10 </FieldName>
155 <Type> 21 </Type>
156 <Length> 4 </Length>
157 <Primary> 0 </Primary>
158 <Null> 0 </Null>
159 <Default> 0 </Default>
160 <DefaultValue> </DefaultValue>
161 </FieldInfo>
162 <FieldInfo>
163 <FieldName> f11 </FieldName>
164 <Type> 22 </Type>
165 <Length> 8 </Length>
166 <Primary> 0 </Primary>
167 <Null> 0 </Null>
168 <Default> 0 </Default>
169 <DefaultValue> </DefaultValue>
170 </FieldInfo>
171 </TableInfo>
172 </Table Information of all tables>
173 <Index Information of all Indexs>
174 <Index Name> idxtinyint_smallint </Index Name>
175 <Index Type> Hash Index </Index Type>
176 <Table Name> t1 </Table Name>
177 <Field Name> f1 </Field Name>
178 <Field Name> f2 </Field Name>
179 <Index Name> idxtinyint_int </Index Name>
180 <Index Type> Hash Index </Index Type>
181 <Table Name> t1 </Table Name>
182 <Field Name> f1 </Field Name>
183 <Field Name> f3 </Field Name>
184 <Index Name> idxtinyint_bigint </Index Name>
185 <Index Type> Hash Index </Index Type>
186 <Table Name> t1 </Table Name>
187 <Field Name> f1 </Field Name>
188 <Field Name> f4 </Field Name>
189 <Index Name> idxtinyint_char </Index Name>
190 <Index Type> Hash Index </Index Type>
191 <Table Name> t1 </Table Name>
192 <Field Name> f1 </Field Name>
193 <Field Name> f5 </Field Name>
194 <Index Name> idxtinyint_varchar </Index Name>
195 <Index Type> Hash Index </Index Type>
196 <Table Name> t1 </Table Name>
197 <Field Name> f1 </Field Name>
198 <Field Name> f6 </Field Name>
199 <Index Name> idxtinyint_date </Index Name>
200 <Index Type> Hash Index </Index Type>
201 <Table Name> t1 </Table Name>
202 <Field Name> f1 </Field Name>
203 <Field Name> f9 </Field Name>
204 <Index Name> idxtinyint_time </Index Name>
205 <Index Type> Hash Index </Index Type>
206 <Table Name> t1 </Table Name>
207 <Field Name> f1 </Field Name>
208 <Field Name> f10 </Field Name>
209 <Index Name> idxsmallint_int </Index Name>
210 <Index Type> Hash Index </Index Type>
211 <Table Name> t1 </Table Name>
212 <Field Name> f2 </Field Name>
213 <Field Name> f3 </Field Name>
214 <Index Name> idxsmallint_bigint </Index Name>
215 <Index Type> Hash Index </Index Type>
216 <Table Name> t1 </Table Name>
217 <Field Name> f2 </Field Name>
218 <Field Name> f4 </Field Name>
219 <Index Name> idxsmallint_char </Index Name>
220 <Index Type> Hash Index </Index Type>
221 <Table Name> t1 </Table Name>
222 <Field Name> f2 </Field Name>
223 <Field Name> f5 </Field Name>
224 <Index Name> idxsmallint_varchar </Index Name>
225 <Index Type> Hash Index </Index Type>
226 <Table Name> t1 </Table Name>
227 <Field Name> f2 </Field Name>
228 <Field Name> f6 </Field Name>
229 <Index Name> idxsmallint_date </Index Name>
230 <Index Type> Hash Index </Index Type>
231 <Table Name> t1 </Table Name>
232 <Field Name> f2 </Field Name>
233 <Field Name> f9 </Field Name>
234 <Index Name> idxsmallint_time </Index Name>
235 <Index Type> Hash Index </Index Type>
236 <Table Name> t1 </Table Name>
237 <Field Name> f2 </Field Name>
238 <Field Name> f10 </Field Name>
239 <Index Name> idxint_bigint </Index Name>
240 <Index Type> Hash Index </Index Type>
241 <Table Name> t1 </Table Name>
242 <Field Name> f3 </Field Name>
243 <Field Name> f4 </Field Name>
244 <Index Name> idxint_char </Index Name>
245 <Index Type> Hash Index </Index Type>
246 <Table Name> t1 </Table Name>
247 <Field Name> f3 </Field Name>
248 <Field Name> f5 </Field Name>
249 <Index Name> idxint_varchar </Index Name>
250 <Index Type> Hash Index </Index Type>
251 <Table Name> t1 </Table Name>
252 <Field Name> f3 </Field Name>
253 <Field Name> f6 </Field Name>
254 <Index Name> idxint_date </Index Name>
255 <Index Type> Hash Index </Index Type>
256 <Table Name> t1 </Table Name>
257 <Field Name> f3 </Field Name>
258 <Field Name> f9 </Field Name>
259 <Index Name> idxint_time </Index Name>
260 <Index Type> Hash Index </Index Type>
261 <Table Name> t1 </Table Name>
262 <Field Name> f3 </Field Name>
263 <Field Name> f10 </Field Name>
264 <Index Name> idxbigint_char </Index Name>
265 <Index Type> Hash Index </Index Type>
266 <Table Name> t1 </Table Name>
267 <Field Name> f4 </Field Name>
268 <Field Name> f5 </Field Name>
269 <Index Name> idxbigint_varchar </Index Name>
270 <Index Type> Hash Index </Index Type>
271 <Table Name> t1 </Table Name>
272 <Field Name> f4 </Field Name>
273 <Field Name> f6 </Field Name>
274 <Index Name> idxbigint_date </Index Name>
275 <Index Type> Hash Index </Index Type>
276 <Table Name> t1 </Table Name>
277 <Field Name> f4 </Field Name>
278 <Field Name> f9 </Field Name>
279 <Index Name> idxbigint_time </Index Name>
280 <Index Type> Hash Index </Index Type>
281 <Table Name> t1 </Table Name>
282 <Field Name> f4 </Field Name>
283 <Field Name> f10 </Field Name>
284 <Index Name> idxchar_varchar </Index Name>
285 <Index Type> Hash Index </Index Type>
286 <Table Name> t1 </Table Name>
287 <Field Name> f5 </Field Name>
288 <Field Name> f6 </Field Name>
289 <Index Name> idxchar_date </Index Name>
290 <Index Type> Hash Index </Index Type>
291 <Table Name> t1 </Table Name>
292 <Field Name> f5 </Field Name>
293 <Field Name> f9 </Field Name>
294 <Index Name> idxchar_time </Index Name>
295 <Index Type> Hash Index </Index Type>
296 <Table Name> t1 </Table Name>
297 <Field Name> f5 </Field Name>
298 <Field Name> f10 </Field Name>
299 <Index Name> idxvarchar_date </Index Name>
300 <Index Type> Hash Index </Index Type>
301 <Table Name> t1 </Table Name>
302 <Field Name> f6 </Field Name>
303 <Field Name> f9 </Field Name>
304 <Index Name> idxvarchar_time </Index Name>
305 <Index Type> Hash Index </Index Type>
306 <Table Name> t1 </Table Name>
307 <Field Name> f6 </Field Name>
308 <Field Name> f10 </Field Name>
309 <Index Name> idxdate_time </Index Name>
310 <Index Type> Hash Index </Index Type>
311 <Table Name> t1 </Table Name>
312 <Field Name> f9 </Field Name>
313 <Field Name> f10 </Field Name>
314 <Index Name> idxtinyint_smallint_int </Index Name>
315 <Index Type> Hash Index </Index Type>
316 <Table Name> t1 </Table Name>
317 <Field Name> f1 </Field Name>
318 <Field Name> f2 </Field Name>
319 <Field Name> f3 </Field Name>
320 <Index Name> idxtinyint_smallint_int_bigint </Index Name>
321 <Index Type> Hash Index </Index Type>
322 <Table Name> t1 </Table Name>
323 <Field Name> f1 </Field Name>
324 <Field Name> f2 </Field Name>
325 <Field Name> f3 </Field Name>
326 <Field Name> f4 </Field Name>
327 <Index Name> idxtinyint_smallint_int_bigint_char </Index Name>
328 <Index Type> Hash Index </Index Type>
329 <Table Name> t1 </Table Name>
330 <Field Name> f1 </Field Name>
331 <Field Name> f2 </Field Name>
332 <Field Name> f3 </Field Name>
333 <Field Name> f4 </Field Name>
334 <Field Name> f5 </Field Name>
335 <Index Name> idxtinyint_smallint_int_bigint_char_varchar </Index Name>
336 <Index Type> Hash Index </Index Type>
337 <Table Name> t1 </Table Name>
338 <Field Name> f1 </Field Name>
339 <Field Name> f2 </Field Name>
340 <Field Name> f3 </Field Name>
341 <Field Name> f4 </Field Name>
342 <Field Name> f5 </Field Name>
343 <Field Name> f6 </Field Name>
344 <Index Name> idxtinyint_smallint_int_bigint_char_varchar_date </Index Name>
345 <Index Type> Hash Index </Index Type>
346 <Table Name> t1 </Table Name>
347 <Field Name> f1 </Field Name>
348 <Field Name> f2 </Field Name>
349 <Field Name> f3 </Field Name>
350 <Field Name> f4 </Field Name>
351 <Field Name> f5 </Field Name>
352 <Field Name> f6 </Field Name>
353 <Field Name> f9 </Field Name>
354 <Index Name> idxtinyint_smallint_int_bigint_char_varchar_date_time </Index Name>
355 <Index Type> Hash Index </Index Type>
356 <Table Name> t1 </Table Name>
357 <Field Name> f1 </Field Name>
358 <Field Name> f2 </Field Name>
359 <Field Name> f3 </Field Name>
360 <Field Name> f4 </Field Name>
361 <Field Name> f5 </Field Name>
362 <Field Name> f6 </Field Name>
363 <Field Name> f9 </Field Name>
364 <Field Name> f10 </Field Name>
365 </Index Information of all Indexs>
366 echo drop table t1;
367 Statement Executed