test/sql/StmtCache/test007.ksh

   1 #!/bin/ksh
   2 # create index statement should remove all the cached statements which are not in use
   3 CREATEFILE=${PWD}/sql/StmtCache/csql.conf
   4 REL_PATH=.
   5 if [ -s "$CREATEFILE" ]
   6 then
   7     REL_PATH=`pwd`/sql/StmtCache
   8 fi
   9
  10 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  11
  12 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  13 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/t1.sql >/dev/null 2>&1
  14
  15
  16 if [ "$VALGRIND" = "true" ]
  17 then
  18     valgrind --tool=memcheck --leak-check=full $REL_PATH/stmtTest7
  19 else
  20     $REL_PATH/stmtTest7
  21     if [ $? -ne 0 ]
  22     then
  23        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  24        rm -f ${REL_PATH}/dropt1.sql
  25        exit 1;
  26     fi
  27 fi
  28 echo "select * from t1 where f1=100;" >${REL_PATH}/sel.sql
  29 echo "explain plan select * from t1 where f1=200;" >>${REL_PATH}/sel.sql
  30 echo "select * from t1 where f1=200;" >>${REL_PATH}/sel.sql
  31 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sel.sql
  32 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  33 rm -f ${REL_PATH}/dropt1.sql
  34
  35 exit 0;