3 # Testing all DML on large size allocate
5 QUITFILE
=${PWD}/tools
/csql
/quit.sql
9 REL_PATH
=`pwd`/tools
/csql
12 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/largetable1.sql
15 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drt1.sql
19 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
22 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
26 echo "update t1 set f2='LAKSHYA-CSQL' where f1>=3;"
27 echo "update t1 set f2='LAKSHYA-CSQL' where f1>=3;" >${REL_PATH}/largetableupdate1.sql
28 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/largetableupdate1.sql
31 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
32 rm -f ${REL_PATH}/largetableupdate1.sql
36 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selectstar.sql
39 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
40 rm -f ${REL_PATH}/largetableupdate1.sql
44 echo "delete from t1 where f1<= 7;"
45 echo "delete from t1 where f1<= 7;" >${REL_PATH}/largetabledelete1.sql
46 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/largetabledelete1.sql
49 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
50 rm -f ${REL_PATH}/largetableupdate1.sql
${REL_PATH}/largetabledelete1.sql
54 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selectstar.sql
57 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
58 rm -f ${REL_PATH}/largetableupdate1.sql
${REL_PATH}/largetabledelete1.sql
62 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
65 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
66 rm -f ${REL_PATH}/largetableupdate1.sql
${REL_PATH}/largetabledelete1.sql
70 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
73 rm -f ${REL_PATH}/largetableupdate1.sql
${REL_PATH}/largetabledelete1.sql
76 rm -f ${REL_PATH}/largetableupdate1.sql
${REL_PATH}/largetabledelete1.sql