test/sql/Optimizer/test013.ksh

   1 #!/bin/ksh
   2 # Create table with 4 fields all are varchar.
   3 # create composite hash index on 3 fields.
   4 # Apply explain plan using select with multiple predicates(Hash lookup).
   5 # Apply explain plan using select with multiple predicates(range lookup).
   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/varchar_composite.sql
  21 else
  22     $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/varchar_composite.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