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
10 if [ -s "$CREATEFILE" ]
12 REL_PATH
=`pwd`/sql
/StmtCache
15 echo "drop table t1;" >${REL_PATH}/dropt1.sql
17 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
>/dev
/null
2>&1
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
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
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
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
35 if [ "$VALGRIND" = "true" ]
37 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache1.sql
39 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache1.sql
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
49 if [ "$VALGRIND" = "true" ]
51 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache2.sql
53 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache2.sql
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
63 if [ "$VALGRIND" = "true" ]
65 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache3.sql
67 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache3.sql
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
78 if [ "$VALGRIND" = "true" ]
80 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache4.sql
82 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/stmtcache4.sql
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
91 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
97 rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/stmtcache1.sql ${REL_PATH}/stmtcache2.sql ${REL_PATH}/stmtcache3.sql ${REL_PATH}/stmtcache4.sql