2 CREATE TABLE t1(f1 TINYINT ,f2 SMALLINT ,f3 INT ,f4 BIGINT ,f5 CHAR(20) ,f6 VARCHAR(30) ,f7 FLOAT ,f8 DOUBLE ,f9 DATE ,f10 TIME ,f11 TIMESTAMP);
4 CREATE INDEX idxtinyint_smallint ON t1(f1,f2) HASH;
5 CREATE INDEX idxtinyint_int ON t1(f1,f3) HASH;
6 CREATE INDEX idxtinyint_bigint ON t1(f1,f4) HASH;
7 CREATE INDEX idxtinyint_char ON t1(f1,f5) HASH;
8 CREATE INDEX idxtinyint_varchar ON t1(f1,f6) HASH;
9 CREATE INDEX idxtinyint_date ON t1(f1,f9) HASH;
10 CREATE INDEX idxtinyint_time ON t1(f1,f10) HASH;
12 CREATE INDEX idxsmallint_tinyint ON t1(f2,f1) HASH; should fail
13 CREATE INDEX idxsmallint_int ON t1(f2,f3) HASH;
14 CREATE INDEX idxsmallint_bigint ON t1(f2,f4) HASH;
15 CREATE INDEX idxsmallint_char ON t1(f2,f5) HASH;
16 CREATE INDEX idxsmallint_varchar ON t1(f2,f6) HASH;
17 CREATE INDEX idxsmallint_date ON t1(f2,f9) HASH;
18 CREATE INDEX idxsmallint_time ON t1(f2,f10) HASH;
20 CREATE INDEX idxint_tinyint ON t1(f3,f1) HASH; should fail
21 CREATE INDEX idxint_smallint ON t1(f3,f2) HASH; should fail
22 CREATE INDEX idxint_bigint ON t1(f3,f4) HASH;
23 CREATE INDEX idxint_char ON t1(f3,f5) HASH;
24 CREATE INDEX idxint_varchar ON t1(f3,f6) HASH;
25 CREATE INDEX idxint_date ON t1(f3,f9) HASH;
26 CREATE INDEX idxint_time ON t1(f3,f10) HASH;
28 CREATE INDEX idxbigint_tinyint ON t1(f4,f1) HASH; should fail
29 CREATE INDEX idxbigint_smallint ON t1(f4,f2) HASH; should fail
30 CREATE INDEX idxbigint_int ON t1(f4,f3) HASH; should fail
31 CREATE INDEX idxbigint_char ON t1(f4,f5) HASH;
32 CREATE INDEX idxbigint_varchar ON t1(f4,f6) HASH;
33 CREATE INDEX idxbigint_date ON t1(f4,f9) HASH;
34 CREATE INDEX idxbigint_time ON t1(f4,f10) HASH;
36 CREATE INDEX idxchar_tinyint ON t1(f5,f1) HASH; should fail
37 CREATE INDEX idxchar_smallint ON t1(f5,f2) HASH; should fail
38 CREATE INDEX idxchar_int ON t1(f5,f3) HASH; should fail
39 CREATE INDEX idxchar_bigint ON t1(f5,f4) HASH; should fail
40 CREATE INDEX idxchar_varchar ON t1(f5,f6) HASH;
41 CREATE INDEX idxchar_date ON t1(f5,f9) HASH;
42 CREATE INDEX idxchar_time ON t1(f5,f10) HASH;
44 CREATE INDEX idxvarchar_tinyint ON t1(f6,f1) HASH; should fail
45 CREATE INDEX idxvarchar_smallint ON t1(f6,f2) HASH; should fail
46 CREATE INDEX idxvarchar_int ON t1(f6,f3) HASH; should fail
47 CREATE INDEX idxvarchar_bigint ON t1(f6,f4) HASH; should fail
48 CREATE INDEX idxvarchar_char ON t1(f6,f5) HASH; should fail
49 CREATE INDEX idxvarchar_date ON t1(f6,f9) HASH;
50 CREATE INDEX idxvarchar_time ON t1(f6,f10) HASH;
52 CREATE INDEX idxdate_tinyint ON t1(f9,f1) HASH; should fail
53 CREATE INDEX idxdate_smallint ON t1(f9,f2) HASH; should fail
54 CREATE INDEX idxdate_int ON t1(f9,f3) HASH; should fail
55 CREATE INDEX idxdate_bigint ON t1(f9,f4) HASH; should fail
56 CREATE INDEX idxdate_char ON t1(f9,f5) HASH; should fail
57 CREATE INDEX idxdate_date ON t1(f9,f6) HASH; should fail
58 CREATE INDEX idxdate_time ON t1(f9,f10) HASH;
60 CREATE INDEX idxtime_tinyint ON t1(f10,f1) HASH; should fail
61 CREATE INDEX idxtime_smallint ON t1(f10,f2) HASH; should fail
62 CREATE INDEX idxtime_int ON t1(f10,f3) HASH; should fail
63 CREATE INDEX idxtime_bigint ON t1(f10,f4) HASH; should fail
64 CREATE INDEX idxtime_char ON t1(f10,f5) HASH; should fail
65 CREATE INDEX idxtime_date ON t1(f10,f6) HASH; should fail
66 CREATE INDEX idxtime_time ON t1(f10,f9) HASH; should fail
68 CREATE INDEX idxtinyint_smallint_int ON t1(f1,f2,f3) HASH;
69 CREATE INDEX idxtinyint_smallint_int_bigint ON t1(f1,f2,f3,f4) HASH;
70 CREATE INDEX idxtinyint_smallint_int_bigint_char ON t1(f1,f2,f3,f4,f5) HASH;
71 CREATE INDEX idxtinyint_smallint_int_bigint_char_varchar ON t1(f1,f2,f3,f4,f5,f6) HASH;
72 CREATE INDEX idxtinyint_smallint_int_bigint_char_varchar_date ON t1(f1,f2,f3,f4,f5,f6,f9) HASH;
73 CREATE INDEX idxtinyint_smallint_int_bigint_char_varchar_date_time ON t1(f1,f2,f3,f4,f5,f6,f9,f10) HASH;
82 AbsSqlConnection
*con
= createConnection();
83 rv
= con
->connect("root","manager");
88 printf("Connection opened\n");
89 AbsSqlStatement
*stmt
= createStatement();
90 stmt
->setConnection(con
);
93 strcpy(statement
,"CREATE TABLE t1(f1 TINYINT ,f2 SMALLINT ,f3 INT ,f4 BIGINT ,f5 CHAR(20) ,f6 VARCHAR(30) ,f7 FLOAT ,f8 DOUBLE ,f9 DATE ,f10 TIME ,f11 TIMESTAMP);");
95 rv
= stmt
->prepare(statement
);
96 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 2; }
97 rv
= stmt
->execute(rows
);
98 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 3; }
99 printf("Table t1 Created\n");
102 rv
= stmt
->prepare("CREATE INDEX idxtinyint_smallint ON t1(f1,f2) HASH;");
103 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 4; }
104 rv
= stmt
->execute(rows
);
105 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 5; }
106 printf("Index Created\n");
109 rv
= stmt
->prepare("CREATE INDEX idxtinyint_int ON t1(f1,f3) HASH;");
110 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 5; }
111 rv
= stmt
->execute(rows
);
112 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 6; }
113 printf("Index Created\n");
116 rv
= stmt
->prepare("CREATE INDEX idxtinyint_bigint ON t1(f1,f4) HASH;");
117 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 7; }
118 rv
= stmt
->execute(rows
);
119 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 8; }
120 printf("Index Created\n");
123 rv
= stmt
->prepare("CREATE INDEX idxtinyint_char ON t1(f1,f5) HASH;");
124 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 9; }
125 rv
= stmt
->execute(rows
);
126 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 10; }
127 printf("Index Created\n");
130 rv
= stmt
->prepare("CREATE INDEX idxtinyint_varchar ON t1(f1,f6) HASH;");
131 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 11; }
132 rv
= stmt
->execute(rows
);
133 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 12; }
134 printf("Index Created\n");
137 rv
= stmt
->prepare("CREATE INDEX idxtinyint_date ON t1(f1,f9) HASH;");
138 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 14; }
139 rv
= stmt
->execute(rows
);
140 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 15; }
141 printf("Index Created\n");
144 rv
= stmt
->prepare("CREATE INDEX idxtinyint_time ON t1(f1,f10) HASH;");
145 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 16; }
146 rv
= stmt
->execute(rows
);
147 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 17; }
148 printf("Index Created\n");
151 rv
= stmt
->prepare("CREATE INDEX idxsmallint_tinyint ON t1(f2,f1) HASH;");
152 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 18; }
153 rv
= stmt
->execute(rows
);
154 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 19; }
155 printf("Index Already Exist\n");
158 rv
= stmt
->prepare("CREATE INDEX idxsmallint_int ON t1(f2,f3) HASH;");
159 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 20; }
160 rv
= stmt
->execute(rows
);
161 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 21; }
162 printf("Index Created\n");
165 rv
= stmt
->prepare("CREATE INDEX idxsmallint_bigint ON t1(f2,f4) HASH;");
166 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 22; }
167 rv
= stmt
->execute(rows
);
168 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 23; }
169 printf("Index Created\n");
172 rv
= stmt
->prepare("CREATE INDEX idxsmallint_char ON t1(f2,f5) HASH;");
173 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 24; }
174 rv
= stmt
->execute(rows
);
175 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 25; }
176 printf("Index Created\n");
179 rv
= stmt
->prepare("CREATE INDEX idxsmallint_varchar ON t1(f2,f6) HASH;");
180 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 26; }
181 rv
= stmt
->execute(rows
);
182 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 27; }
183 printf("Index Created\n");
186 rv
= stmt
->prepare("CREATE INDEX idxsmallint_date ON t1(f2,f9) HASH;");
187 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 28; }
188 rv
= stmt
->execute(rows
);
189 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 29; }
190 printf("Index Created\n");
193 rv
= stmt
->prepare("CREATE INDEX idxsmallint_time ON t1(f2,f10) HASH;");
194 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 30; }
195 rv
= stmt
->execute(rows
);
196 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 31; }
197 printf("Index Created\n");
200 rv
= stmt
->prepare("CREATE INDEX idxint_tinyint ON t1(f3,f1) HASH;");
201 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 32; }
202 rv
= stmt
->execute(rows
);
203 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 33; }
204 printf("Index Already Exist\n");
207 rv
= stmt
->prepare("CREATE INDEX idxint_smallint ON t1(f3,f2) HASH;");
208 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 34; }
209 rv
= stmt
->execute(rows
);
210 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 35; }
211 printf("Index Already Exist\n");
214 rv
= stmt
->prepare("CREATE INDEX idxint_bigint ON t1(f3,f4) HASH;");
215 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 36; }
216 rv
= stmt
->execute(rows
);
217 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 37; }
218 printf("Index Created\n");
221 rv
= stmt
->prepare("CREATE INDEX idxint_char ON t1(f3,f5) HASH;");
222 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 38; }
223 rv
= stmt
->execute(rows
);
224 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 39; }
225 printf("Index Created\n");
228 rv
= stmt
->prepare("CREATE INDEX idxint_varchar ON t1(f3,f6) HASH;");
229 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 40; }
230 rv
= stmt
->execute(rows
);
231 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 41; }
232 printf("Index Created\n");
235 rv
= stmt
->prepare("CREATE INDEX idxint_date ON t1(f3,f9) HASH;");
236 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 42; }
237 rv
= stmt
->execute(rows
);
238 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 43; }
239 printf("Index Created\n");
242 rv
= stmt
->prepare("CREATE INDEX idxint_time ON t1(f3,f10) HASH;");
243 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 44; }
244 rv
= stmt
->execute(rows
);
245 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 45; }
246 printf("Index Created\n");
249 rv
= stmt
->prepare("CREATE INDEX idxbigint_tinyint ON t1(f4,f1) HASH;");
250 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 46; }
251 rv
= stmt
->execute(rows
);
252 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 47; }
253 printf("Index Already Exist\n");
256 rv
= stmt
->prepare("CREATE INDEX idxbigint_smallint ON t1(f4,f2) HASH;");
257 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 48; }
258 rv
= stmt
->execute(rows
);
259 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 49; }
260 printf("Index Already Exist\n");
263 rv
= stmt
->prepare("CREATE INDEX idxbigint_int ON t1(f4,f3) HASH;");
264 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 50; }
265 rv
= stmt
->execute(rows
);
266 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 51; }
267 printf("Index Already Exist\n");
270 rv
= stmt
->prepare("CREATE INDEX idxbigint_char ON t1(f4,f5) HASH;");
271 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 52; }
272 rv
= stmt
->execute(rows
);
273 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 53; }
274 printf("Index Created\n");
277 rv
= stmt
->prepare("CREATE INDEX idxbigint_varchar ON t1(f4,f6) HASH;");
278 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 54; }
279 rv
= stmt
->execute(rows
);
280 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 55; }
281 printf("Index Created\n");
284 rv
= stmt
->prepare("CREATE INDEX idxbigint_date ON t1(f4,f9) HASH;");
285 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 55; }
286 rv
= stmt
->execute(rows
);
287 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 56; }
288 printf("Index Created\n");
291 rv
= stmt
->prepare("CREATE INDEX idxbigint_time ON t1(f4,f10) HASH;");
292 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 57; }
293 rv
= stmt
->execute(rows
);
294 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 58; }
295 printf("Index Created\n");
298 rv
= stmt
->prepare("CREATE INDEX idxchar_tinyint ON t1(f5,f1) HASH;");
299 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 59; }
300 rv
= stmt
->execute(rows
);
301 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 60; }
302 printf("Index Already Exist\n");
305 rv
= stmt
->prepare("CREATE INDEX idxchar_smallint ON t1(f5,f2) HASH;");
306 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 61; }
307 rv
= stmt
->execute(rows
);
308 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 62; }
309 printf("Index Already Exist\n");
312 rv
= stmt
->prepare("CREATE INDEX idxchar_int ON t1(f5,f3) HASH;");
313 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 63; }
314 rv
= stmt
->execute(rows
);
315 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 64; }
316 printf("Index Already Exist\n");
319 rv
= stmt
->prepare("CREATE INDEX idxchar_bigint ON t1(f5,f4) HASH;");
320 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 65; }
321 rv
= stmt
->execute(rows
);
322 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 66; }
323 printf("Index Already Exist\n");
326 rv
= stmt
->prepare("CREATE INDEX idxchar_varchar ON t1(f5,f6) HASH;");
327 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 67; }
328 rv
= stmt
->execute(rows
);
329 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 68; }
330 printf("Index Created\n");
333 rv
= stmt
->prepare("CREATE INDEX idxchar_date ON t1(f5,f9) HASH;");
334 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 69; }
335 rv
= stmt
->execute(rows
);
336 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 70; }
337 printf("Index Created\n");
340 rv
= stmt
->prepare("CREATE INDEX idxchar_time ON t1(f5,f10) HASH;");
341 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 71; }
342 rv
= stmt
->execute(rows
);
343 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 72; }
344 printf("Index Created\n");
347 rv
= stmt
->prepare("CREATE INDEX idxvarchar_tinyint ON t1(f6,f1) HASH;");
348 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 73; }
349 rv
= stmt
->execute(rows
);
350 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 74; }
351 printf("Index Already Exist\n");
354 rv
= stmt
->prepare("CREATE INDEX idxvarchar_smallint ON t1(f6,f2) HASH;");
355 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 75; }
356 rv
= stmt
->execute(rows
);
357 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 76; }
358 printf("Index Already Exist\n");
361 rv
= stmt
->prepare("CREATE INDEX idxvarchar_int ON t1(f6,f3) HASH;");
362 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 77; }
363 rv
= stmt
->execute(rows
);
364 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 78; }
365 printf("Index Already Exist\n");
368 rv
= stmt
->prepare("CREATE INDEX idxvarchar_bigint ON t1(f6,f4) HASH;");
369 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 79; }
370 rv
= stmt
->execute(rows
);
371 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 80; }
372 printf("Index Already Exist\n");
375 rv
= stmt
->prepare("CREATE INDEX idxvarchar_char ON t1(f6,f5) HASH;");
376 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 81; }
377 rv
= stmt
->execute(rows
);
378 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 82; }
379 printf("Index Already Exist\n");
382 rv
= stmt
->prepare("CREATE INDEX idxvarchar_date ON t1(f6,f9) HASH;");
383 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 83; }
384 rv
= stmt
->execute(rows
);
385 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 84; }
386 printf("Index Created\n");
389 rv
= stmt
->prepare("CREATE INDEX idxvarchar_time ON t1(f6,f10) HASH;");
390 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 85; }
391 rv
= stmt
->execute(rows
);
392 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 86; }
393 printf("Index Created\n");
396 rv
= stmt
->prepare("CREATE INDEX idxdate_tinyint ON t1(f9,f1) HASH;");
397 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 87; }
398 rv
= stmt
->execute(rows
);
399 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 88; }
400 printf("Index Already Exist\n");
403 rv
= stmt
->prepare("CREATE INDEX idxdate_smallint ON t1(f9,f2) HASH;");
404 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 89; }
405 rv
= stmt
->execute(rows
);
406 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 90; }
407 printf("Index Already Exist\n");
410 rv
= stmt
->prepare("CREATE INDEX idxdate_int ON t1(f9,f3) HASH;");
411 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 91; }
412 rv
= stmt
->execute(rows
);
413 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 92; }
414 printf("Index Already Exist\n");
417 rv
= stmt
->prepare("CREATE INDEX idxdate_bigint ON t1(f9,f4) HASH;");
418 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 93; }
419 rv
= stmt
->execute(rows
);
420 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 94; }
421 printf("Index Already Exist\n");
424 rv
= stmt
->prepare("CREATE INDEX idxdate_char ON t1(f9,f5) HASH;");
425 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 95; }
426 rv
= stmt
->execute(rows
);
427 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 96; }
428 printf("Index Already Exist\n");
431 rv
= stmt
->prepare("CREATE INDEX idxdate_date ON t1(f9,f6) HASH;");
432 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 97; }
433 rv
= stmt
->execute(rows
);
434 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 98; }
435 printf("Index Already Exist\n");
438 rv
= stmt
->prepare("CREATE INDEX idxdate_time ON t1(f9,f10) HASH;");
439 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 99; }
440 rv
= stmt
->execute(rows
);
441 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 100; }
442 printf("Index Created\n");
445 rv
= stmt
->prepare("CREATE INDEX idxtime_tinyint ON t1(f10,f1) HASH;");
446 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 101; }
447 rv
= stmt
->execute(rows
);
448 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 102; }
449 printf("Index Already Exist\n");
452 rv
= stmt
->prepare("CREATE INDEX idxtime_smallint ON t1(f10,f2) HASH;");
453 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 103; }
454 rv
= stmt
->execute(rows
);
455 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 104; }
456 printf("Index Already Exist\n");
459 rv
= stmt
->prepare("CREATE INDEX idxtime_int ON t1(f10,f3) HASH;");
460 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 105; }
461 rv
= stmt
->execute(rows
);
462 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 106; }
463 printf("Index Already Exist\n");
466 rv
= stmt
->prepare("CREATE INDEX idxtime_bigint ON t1(f10,f4) HASH;");
467 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 107; }
468 rv
= stmt
->execute(rows
);
469 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 108; }
470 printf("Index Already Exist\n");
473 rv
= stmt
->prepare("CREATE INDEX idxtime_char ON t1(f10,f5) HASH;");
474 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 109; }
475 rv
= stmt
->execute(rows
);
476 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 110; }
477 printf("Index Already Exist\n");
480 rv
= stmt
->prepare("CREATE INDEX idxtime_date ON t1(f10,f6) HASH;");
481 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 111; }
482 rv
= stmt
->execute(rows
);
483 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 112; }
484 printf("Index Already Exist\n");
487 rv
= stmt
->prepare("CREATE INDEX idxtime_time ON t1(f10,f9) HASH;");
488 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 113; }
489 rv
= stmt
->execute(rows
);
490 if(rv
==OK
) { delete stmt
; con
->disconnect(); delete con
; return 114; }
491 printf("Index Already Exist\n");
494 rv
= stmt
->prepare("CREATE INDEX idxtinyint_smallint_int ON t1(f1,f2,f3) HASH;");
495 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 115; }
496 rv
= stmt
->execute(rows
);
497 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 116; }
498 printf("Index Created\n");
501 rv
= stmt
->prepare("CREATE INDEX idxtinyint_smallint_int_bigint ON t1(f1,f2,f3,f4) HASH;");
502 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 117; }
503 rv
= stmt
->execute(rows
);
504 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 118; }
505 printf("Index Created\n");
508 rv
= stmt
->prepare("CREATE INDEX idxtinyint_smallint_int_bigint_char ON t1(f1,f2,f3,f4,f5) HASH;");
509 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 119; }
510 rv
= stmt
->execute(rows
);
511 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 120; }
512 printf("Index Created\n");
515 rv
= stmt
->prepare("CREATE INDEX idxtinyint_smallint_int_bigint_char_varchar ON t1(f1,f2,f3,f4,f5,f6) HASH;");
516 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 121; }
517 rv
= stmt
->execute(rows
);
518 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 122; }
519 printf("Index Created\n");
522 rv
= stmt
->prepare("CREATE INDEX idxtinyint_smallint_int_bigint_char_varchar_date ON t1(f1,f2,f3,f4,f5,f6,f9) HASH;");
523 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 123; }
524 rv
= stmt
->execute(rows
);
525 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 124; }
526 printf("Index Created\n");
529 rv
= stmt
->prepare("CREATE INDEX idxtinyint_smallint_int_bigint_char_varchar_date_time ON t1(f1,f2,f3,f4,f5,f6,f9,f10) HASH;");
530 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 125; }
531 rv
= stmt
->execute(rows
);
532 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 126; }
533 printf("Index Created\n");
537 strcpy(statement
,"GETALLTABLES;");
539 rv
= stmt
->prepare(statement
);
540 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 127; }
542 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 128; }
543 printf("\t TABLES\n");
544 printf("\t--------\n");
545 while(stmt
->next() !=NULL
) {
546 printf("\t%s\n",stmt
->getFieldValuePtr(2)); //stmt->getFieldValuePtr(2) returns the TABLE_NAME (src/sql/SqlStatement.cxx)
551 printf("Connection Closed\n");
553 delete stmt
; delete con
;