2 # The same is present in testnw028.ksh (wih network)
3 # Default and 'now' testing for Date, Time and Timestamp datatypes
6 QUITFILE
=${PWD}/tools
/csql
/quit.sql
10 REL_PATH
=`pwd`/tools
/csql
13 if [ "$VALGRIND" = "true" ]
15 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/csqlnow.sql
2> $0.valgr
17 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/csqlnow.sql
26 echo "echo INSERT INTO t1(f2) VALUES('NOW');" >${REL_PATH}/insnow.sql
27 echo "INSERT INTO t1(f2) VALUES('NOW');" >>${REL_PATH}/insnow.sql
28 if [ "$VALGRIND" = "true" ]
30 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insnow.sql
2>> $0.valgr
32 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insnow.sql
35 rm -f ${REL_PATH}/insnow.sql
36 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
42 echo "echo INSERT INTO t1(f3) VALUES('NOW');" >${REL_PATH}/insnow.sql
43 echo "INSERT INTO t1(f3) VALUES('NOW');" >>${REL_PATH}/insnow.sql
44 if [ "$VALGRIND" = "true" ]
46 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insnow.sql
2>> $0.valgr
48 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insnow.sql
51 rm -f ${REL_PATH}/insnow.sql
52 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
58 echo "echo INSERT INTO t1(f4) VALUES('NOW');" >${REL_PATH}/insnow.sql
59 echo "INSERT INTO t1(f4) VALUES('NOW');" >>${REL_PATH}/insnow.sql
60 if [ "$VALGRIND" = "true" ]
62 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insnow.sql
2>> $0.valgr
64 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insnow.sql
67 rm -f ${REL_PATH}/insnow.sql
68 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
73 echo "echo SELECT * FROM t1;" >${REL_PATH}/selnow.sql
74 echo "SELECT * FROM t1;" >>${REL_PATH}/selnow.sql
75 if [ "$VALGRIND" = "true" ]
77 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selnow.sql
2>> $0.valgr
79 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selnow.sql
82 rm -f ${REL_PATH}/insnow.sql
83 rm -f ${REL_PATH}/selnow.sql
84 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
89 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
92 rm -f ${REL_PATH}/insnow.sql
96 rm -f ${REL_PATH}/insnow.sql
97 rm -f ${REL_PATH}/selnow.sql