2 #create table t1 with f1 int and f2 char(20). insert 10 different record.
3 #create table ct1 with f1 int ,f2 char(20)
4 #create table ct2 with f1 int
5 #create table ct3 with f1 char(20)
6 # a. insert into ct1 as select * from t1;
7 # b. insert into ct2 as select f1 from t1;
8 # c.insert into ct3 as select f2 from t1;
10 QUITFILE
=${PWD}/tools
/copystmt
/quit.sql
14 REL_PATH
=`pwd`/tools
/copystmt
17 echo "echo create table t1(f1 int,f2 char(20));" >${REL_PATH}/create_t1.sql
18 echo "create table t1(f1 int,f2 char(20));" >>${REL_PATH}/create_t1.sql
22 echo "insert into t1 values($i,'CSQL$i');" >>${REL_PATH}/create_t1.sql
26 echo "echo create table ct1 (f1 int, f2 char(20));" >${REL_PATH}/create_ct1.sql
27 echo "create table ct1 (f1 int, f2 char(20));" >>${REL_PATH}/create_ct1.sql
29 echo "echo create table ct2(f1 int);" >${REL_PATH}/create_ct2.sql
30 echo "create table ct2(f1 int);" >>${REL_PATH}/create_ct2.sql
32 echo "echo create table ct3(f1 char(20));" >${REL_PATH}/create_ct3.sql
33 echo "create table ct3(f1 char(20));" >>${REL_PATH}/create_ct3.sql
35 echo "echo insert into ct1 as select * from t1;" >${REL_PATH}/insertinto_ct1.sql
36 echo "insert into ct1 as select * from t1;" >>${REL_PATH}/insertinto_ct1.sql
38 echo "echo insert into ct2 as select f1 from t1;" >${REL_PATH}/insertinto_ct2.sql
39 echo "insert into ct2 as select f1 from t1;" >>${REL_PATH}/insertinto_ct2.sql
41 echo "echo insert into ct3 as select f2 from t1;" >${REL_PATH}/insertinto_ct3.sql
42 echo "insert into ct3 as select f2 from t1;" >>${REL_PATH}/insertinto_ct3.sql
44 echo "Drop table t1;" >${REL_PATH}/drop.sql
45 echo "Drop table ct1;">>${REL_PATH}/drop.sql
46 echo "Drop table ct2;">>${REL_PATH}/drop.sql
47 echo "Drop table ct3;">>${REL_PATH}/drop.sql
49 if [ "$VALGRIND" = "true" ]
51 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_t1.sql
2> $0.valgr
53 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_t1.sql
57 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
62 if [ "$VALGRIND" = "true" ]
64 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_ct1.sql
2>> $0.valgr
66 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_ct1.sql
70 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
75 if [ "$VALGRIND" = "true" ]
77 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_ct2.sql
2>> $0.valgr
79 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_ct2.sql
83 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
88 if [ "$VALGRIND" = "true" ]
90 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_ct3.sql
2>> $0.valgr
92 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_ct3.sql
96 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
101 if [ "$VALGRIND" = "true" ]
103 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insertinto_ct1.sql
2>> $0.valgr
105 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insertinto_ct1.sql
109 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
114 if [ "$VALGRIND" = "true" ]
116 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insertinto_ct2.sql
2>> $0.valgr
118 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insertinto_ct2.sql
122 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
127 if [ "$VALGRIND" = "true" ]
129 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insertinto_ct3.sql
2>> $0.valgr
131 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insertinto_ct3.sql
135 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
140 if [ "$VALGRIND" = "true" ]
142 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
144 $CSQL_INSTALL_ROOT/bin
/csqldump
148 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql
153 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
154 rm -f ${REL_PATH}/create_t1.sql ${REL_PATH}/create_ct1.sql.sql ${REL_PATH}/create_ct2.sql ${REL_PATH}/create_ct3.sql ${REL_PATH}/insertinto_ct1.sql ${REL_PATH}/insertinto_ct2.sql ${REL_PATH}/insertinto_ct3.sql ${REL_PATH}/drop.sql