test/sql/Optimizer/test004.ksh

   1 #!/bin/ksh
   2 # Explain plan on all datatypes with single predicate applying tree index(Relational Operators).
   3 # Create table with all datatypes
   4 # Create simple tree index on each datatypes.
   5 # Apply explain plan on each datatypes using select with where clause.
   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/tree_singleprrdicate.sql
  21 else
  22     $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/tree_singleprrdicate.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