test/sql/StmtCache/test001.ksh

   1 #!/bin/ksh
   2 # Statement Caching test with now in timestamp field
   3 # create a table say t1(f1 int, f2 timestamp)
   4 # insert a record say (1,'now')
   5 # select count(*) from t1 where f2 < 'now'; This should display 1
   6 # insert a record say (2,'now')
   7 # select count(*) from t1 where f2 < 'now'; This should display 2
   8 CREATEFILE=${PWD}/sql/StmtCache/csql.conf
   9 REL_PATH=.
  10 if [ -s "$CREATEFILE" ]
  11 then
  12     REL_PATH=`pwd`/sql/StmtCache
  13 fi
  14
  15 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  16
  17 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  18
  19 echo "echo create table t1(f1 int, f2 timestamp);" >${REL_PATH}/stmtcache1.sql
  20 echo "create table t1(f1 int, f2 timestamp);" >>${REL_PATH}/stmtcache1.sql
  21 echo "echo insert into t1 values(1,'now');" >>${REL_PATH}/stmtcache1.sql
  22 echo "insert into t1 values(1,'now');" >>${REL_PATH}/stmtcache1.sql
  23
  24 echo "echo select count(*) from t1 where f2 < 'now';" >${REL_PATH}/stmtcache2.sql
  25 echo "select count(*) from t1 where f2 < 'now';" >>${REL_PATH}/stmtcache2.sql
  26
  27 echo "echo insert into t1 values(2,'now');" >${REL_PATH}/stmtcache3.sql
  28 echo "insert into t1 values(2,'now');" >>${REL_PATH}/stmtcache3.sql
  29
  30 echo "echo select count(*) from t1 where f2 < 'now';" >${REL_PATH}/stmtcache4.sql
  31 echo "select count(*) from t1 where f2 < 'now';" >>${REL_PATH}/stmtcache4.sql
  32
  33 sleep 1
  34
  35 if [ "$VALGRIND" = "true" ]
  36 then
  37     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache1.sql
  38 else
  39     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache1.sql
  40     if [ $? -ne 0 ]
  41     then
  42        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  43        rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/stmtcache1.sql ${REL_PATH}/stmtcache2.sql ${REL_PATH}/stmtcache3.sql ${REL_PATH}/stmtcache4.sql
  44        exit 1;
  45     fi
  46 fi
  47 sleep 1
  48
  49 if [ "$VALGRIND" = "true" ]
  50 then
  51     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache2.sql
  52 else
  53     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache2.sql
  54     if [ $? -ne 0 ]
  55     then
  56        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  57        rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/stmtcache1.sql ${REL_PATH}/stmtcache2.sql ${REL_PATH}/stmtcache3.sql ${REL_PATH}/stmtcache4.sql
  58        exit 1;
  59     fi
  60 fi
  61 sleep 1
  62
  63 if [ "$VALGRIND" = "true" ]
  64 then
  65     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache3.sql
  66 else
  67     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache3.sql
  68     if [ $? -ne 0 ]
  69     then
  70        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  71        rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/stmtcache1.sql ${REL_PATH}/stmtcache2.sql ${REL_PATH}/stmtcache3.sql ${REL_PATH}/stmtcache4.sql
  72        exit 3;
  73     fi
  74 fi
  75
  76 sleep 1
  77
  78 if [ "$VALGRIND" = "true" ]
  79 then
  80     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache4.sql
  81 else
  82     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/stmtcache4.sql
  83     if [ $? -ne 0 ]
  84     then
  85        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  86        rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/stmtcache1.sql ${REL_PATH}/stmtcache2.sql ${REL_PATH}/stmtcache3.sql ${REL_PATH}/stmtcache4.sql
  87        exit 4;
  88     fi
  89 fi
  90
  91 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  92 if [ $? -ne 0 ]
  93 then
  94    exit 5;
  95 fi
  96
  97 rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/stmtcache1.sql ${REL_PATH}/stmtcache2.sql ${REL_PATH}/stmtcache3.sql ${REL_PATH}/stmtcache4.sql
  98 exit 0;