adding test scripts
[csql.git] / test / sql / ScalarFunction / test043.ksh
blobaaeb630419d3799148483446b7f396e907451bd6
1 #!/bin/ksh
2 #Testing Now() for Timestamp
3 CREATEFILE=${PWD}/sql/ScalarFunction/csql.conf
4 REL_PATH=.
5 if [ -s "$CREATEFILE" ]
6 then
7 REL_PATH=`pwd`/sql/ScalarFunction
8 fi
10 echo "drop table t1;" >${REL_PATH}/dropt1.sql
12 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
14 if [ "$VALGRIND" = "true" ]
15 then
16 valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/timestamp_with_now.sql
18 else
19 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/timestamp_with_now.sql
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;
29 rm -f ${REL_PATH}/dropt1.sql
30 exit 0;