test/sqlapi/Csql/DDLStmt/compositehashonalldatatype.c

   1 /*
   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);
   3
   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;
  11
  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;
  19
  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;
  27
  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;
  35
  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;
  43
  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;
  51
  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;
  59
  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
  67
  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;
  74
  75 */
  76
  77 #include"common.h"
  78
  79 int main()
  80 {
  81     DbRetVal rv = OK;
  82     AbsSqlConnection *con = createConnection();
  83     rv = con->connect("root","manager");
  84     if(rv !=OK) {
  85         delete con;
  86         return 1;
  87     }
  88     printf("Connection opened\n");
  89     AbsSqlStatement *stmt = createStatement();
  90     stmt->setConnection(con);
  91 //Creating Table
  92     char statement[400];
  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);");
  94     int rows=0;
  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");
 100     stmt->free();
 101
 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");
 107     stmt->free();
 108
 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");
 114     stmt->free();
 115
 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");
 121     stmt->free();
 122
 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");
 128     stmt->free();
 129
 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");
 135     stmt->free();
 136
 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");
 142     stmt->free();
 143
 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");
 149     stmt->free();
 150
 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");
 156     stmt->free();
 157
 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");
 163     stmt->free();
 164
 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");
 170     stmt->free();
 171
 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");
 177     stmt->free();
 178
 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");
 184     stmt->free();
 185
 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");
 191     stmt->free();
 192
 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");
 198     stmt->free();
 199
 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");
 205     stmt->free();
 206
 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");
 212     stmt->free();
 213
 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");
 219     stmt->free();
 220
 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");
 226     stmt->free();
 227
 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");
 233     stmt->free();
 234
 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");
 240     stmt->free();
 241
 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");
 247     stmt->free();
 248
 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");
 254     stmt->free();
 255
 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");
 261     stmt->free();
 262
 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");
 268     stmt->free();
 269
 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");
 275     stmt->free();
 276
 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");
 282     stmt->free();
 283
 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");
 289     stmt->free();
 290
 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");
 296     stmt->free();
 297
 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");
 303     stmt->free();
 304
 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");
 310     stmt->free();
 311
 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");
 317     stmt->free();
 318
 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");
 324     stmt->free();
 325
 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");
 331     stmt->free();
 332
 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");
 338     stmt->free();
 339
 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");
 345     stmt->free();
 346
 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");
 352     stmt->free();
 353
 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");
 359     stmt->free();
 360
 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");
 366     stmt->free();
 367
 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");
 373     stmt->free();
 374
 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");
 380     stmt->free();
 381
 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");
 387     stmt->free();
 388
 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");
 394     stmt->free();
 395
 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");
 401     stmt->free();
 402
 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");
 408     stmt->free();
 409
 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");
 415     stmt->free();
 416
 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");
 422     stmt->free();
 423
 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");
 429     stmt->free();
 430
 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");
 436     stmt->free();
 437
 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");
 443     stmt->free();
 444
 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");
 450     stmt->free();
 451
 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");
 457     stmt->free();
 458
 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");
 464     stmt->free();
 465
 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");
 471     stmt->free();
 472
 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");
 478     stmt->free();
 479
 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");
 485     stmt->free();
 486
 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");
 492     stmt->free();
 493
 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");
 499     stmt->free();
 500
 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");
 506     stmt->free();
 507
 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");
 513     stmt->free();
 514
 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");
 520     stmt->free();
 521
 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");
 527     stmt->free();
 528
 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");
 534     stmt->free();
 535
 536 // Show all tables
 537     strcpy(statement,"GETALLTABLES;");
 538     rows=0;
 539     rv = stmt->prepare(statement);
 540     if(rv!=OK) { delete stmt; con->disconnect(); delete con; return 127; }
 541     stmt->execute(rows);
 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)
 547     }
 548     stmt->free();
 549
 550     con->disconnect();
 551     printf("Connection Closed\n");
 552
 553     delete stmt; delete con;
 554     return 0;
 555 }
 556