test/sqlapi/Csql/DDLStmt/test008.ksh

   1 #!/bin/ksh
   2 # Create Tree indexes on the fields which are (TINYINT,SMALLINT,INT,BIGINT,CHAR,VARCHAR,DATE,TIME).
   3 # 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 idxtiny ON t1(f1) TREE;
   5 # CREATE INDEX idxsmall ON t1(f2) TREE;
   6 # CREATE INDEX idxint ON t1(f3) TREE;
   7 # CREATE INDEX idxbig ON t1(f4) TREE;
   8 # CREATE INDEX idxchar ON t1(f5) TREE;
   9 # CREATE INDEX idxvarchar ON t(f6) TREE;
  10 # CREATE INDEX idxfloat ON t1(f7) TREE;
  11 # CREATE INDEX idxdouble ON t1(f8) TREE;
  12 # CREATE INDEX idxdate ON t(f9) TREE;
  13 # CREATE INDEX idxtime ON t1(f10) TREE;
  14 # CREATE INDEX idxtimestamp ON t1(f11) TREE;
  15 # All the indexes needs to be created
  16
  17 FILE=${PWD}/sqlapi/Csql/DDLStmt/treeindexonalldatatype
  18 REL_PATH=.
  19 if [ -s "$FILE" ]
  20 then
  21     REL_PATH=`pwd`/sqlapi/Csql/DDLStmt
  22 fi
  23
  24 if [ "$VALGRIND" = "true" ]
  25 then
  26     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/treeindexonalldatatype
  27 else
  28     $REL_PATH/treeindexonalldatatype
  29 fi
  30
  31 if [ "$VALGRIND" = "true" ]
  32 then
  33     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  34 else
  35    $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  36 fi
  37
  38 echo "echo drop table t1;" >${REL_PATH}/drop_t1.sql
  39 echo "drop table t1;" >>${REL_PATH}/drop_t1.sql
  40
  41 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
  42 rm -f ${REL_PATH}/drop_t1.sql
  43 exit 0