test/sql/StmtCache/test005.ksh

   1 #!/bin/ksh
   2 # drop table on one table should not affect already prepared stmt
   3 # on another table
   4 CREATEFILE=${PWD}/sql/StmtCache/csql.conf
   5 REL_PATH=.
   6 if [ -s "$CREATEFILE" ]
   7 then
   8     REL_PATH=`pwd`/sql/StmtCache
   9 fi
  10
  11 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  12 echo "drop table t2;" >>${REL_PATH}/dropt1.sql
  13
  14 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  15 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/t1.sql >/dev/null 2>&1
  16 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/t2.sql >/dev/null 2>&1
  17
  18
  19 if [ "$VALGRIND" = "true" ]
  20 then
  21     valgrind --tool=memcheck --leak-check=full $REL_PATH/stmtTest5
  22 else
  23     $REL_PATH/stmtTest5
  24     if [ $? -ne 0 ]
  25     then
  26        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  27        rm -f ${REL_PATH}/dropt1.sql
  28        exit 1;
  29     fi
  30 fi
  31 $CSQL_INSTALL_ROOT/bin/csqldump
  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;