2 # Network test. The same is present in test128.ksh (wihout 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 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -u root
-p manager
-s ${REL_PATH}/csqlnow.sql
20 echo "echo INSERT INTO t1(f2) VALUES('NOW');" >${REL_PATH}/insnow.sql
21 echo "INSERT INTO t1(f2) VALUES('NOW');" >>${REL_PATH}/insnow.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -u root
-p manager
-s ${REL_PATH}/insnow.sql
25 rm -f ${REL_PATH}/insnow.sql
26 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
31 echo "echo INSERT INTO t1(f3) VALUES('NOW');" >${REL_PATH}/insnow.sql
32 echo "INSERT INTO t1(f3) VALUES('NOW');" >>${REL_PATH}/insnow.sql
33 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -u root
-p manager
-s ${REL_PATH}/insnow.sql
36 rm -f ${REL_PATH}/insnow.sql
37 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
42 echo "echo INSERT INTO t1(f4) VALUES('NOW');" >${REL_PATH}/insnow.sql
43 echo "INSERT INTO t1(f4) VALUES('NOW');" >>${REL_PATH}/insnow.sql
44 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -u root
-p manager
-s ${REL_PATH}/insnow.sql
47 rm -f ${REL_PATH}/insnow.sql
48 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
52 echo "echo SELECT * FROM t1;" >${REL_PATH}/selnow.sql
53 echo "SELECT * FROM t1;" >>${REL_PATH}/selnow.sql
54 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -u root
-p manager
-s ${REL_PATH}/selnow.sql
57 rm -f ${REL_PATH}/insnow.sql
58 rm -f ${REL_PATH}/selnow.sql
59 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
63 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
66 rm -f ${REL_PATH}/insnow.sql
70 rm -f ${REL_PATH}/insnow.sql
71 rm -f ${REL_PATH}/selnow.sql