test/sql/Optimizer/test007.ksh

   1 #!/bin/ksh
   2 # IN, BETWEEN and LIKE operator test on Hash Index along with '=' operator
   3 # Create table with all datatypes
   4 # create simple hash index on each datatypes.
   5 # Apply explain plan using select with multiple predicates.(in,between,like predicates along with '=' operator).
   6 #
   7 QUITFILE=${PWD}/sql/Optimizer/drop.sql
   8 REL_PATH=.
   9 if [ -s "$QUITFILE" ]
  10 then
  11 REL_PATH=`pwd`/sql/Optimizer
  12 fi
  13
  14 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  15
  16 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  17
  18 if [ "$VALGRIND" = "true" ]
  19 then
  20     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/hash_multiplepredicate.sql
  21 else
  22     $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/hash_multiplepredicate.sql
  23     if [ $? -ne 0 ]
  24     then
  25       rm -f ${REL_PATH}/dropt1.sql
  26       exit 1;
  27     fi
  28 fi
  29
  30 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1.sql
  31 rm -f ${REL_PATH}/dropt1.sql
  32 exit 0;
  33