3 # Create table t1(f1 int, f2 varchar(10), f3 char(10), f4 varchar(10));
4 # Create table t2 as select f2,f1,f4 from t1;
5 # Run catalog tool for check the indexes are made properly or not.
7 CREATEFILE
=${PWD}/sql
/Datatype
/csql.conf
9 if [ -s "$CREATEFILE" ]
11 REL_PATH
=`pwd`/sql
/Datatype
14 echo "echo Create table t1(f1 int, f2 varchar(10), f3 char(10), f4 varchar(10));" >${REL_PATH}/varchar_copystmt.sql
15 echo "Create table t1(f1 int, f2 varchar(10), f3 char(10), f4 varchar(10));" >>${REL_PATH}/varchar_copystmt.sql
16 echo "echo Create table t2 as select f2,f1,f4 from t1;" >>${REL_PATH}/varchar_copystmt.sql
17 echo "Create table t2 as select f2,f1,f4 from t1;" >>${REL_PATH}/varchar_copystmt.sql
18 echo "echo show tables;" >>${REL_PATH}/varchar_copystmt.sql
19 echo "show tables;" >>${REL_PATH}/varchar_copystmt.sql
21 echo "drop table t1;" >${REL_PATH}/drop.sql
22 echo "drop table t2;" >>${REL_PATH}/drop.sql
24 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
>/dev
/null
2>&1
26 if [ "$VALGRIND" = "true" ]
28 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_copystmt.sql
30 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_copystmt.sql
33 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
34 rm -f ${REL_PATH}/varchar_copystmt.sql
${REL_PATH}/drop.sql
39 if [ "$VALGRIND" = "true" ]
41 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
43 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
46 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
52 rm -f ${REL_PATH}/varchar_copystmt.sql
${REL_PATH}/drop.sql