3 # Create table t1(f1 varchar(10), f2 bigint);
4 # alter table t1 rename column f1 to F1.
5 # rename table t1 to T1.
7 CREATEFILE
=${PWD}/sql
/Datatype
/csql.conf
9 if [ -s "$CREATEFILE" ]
11 REL_PATH
=`pwd`/sql
/Datatype
14 echo "echo Create table t1(f1 varchar(10), f2 bigint);" >${REL_PATH}/varchar_alter.sql
15 echo "Create table t1(f1 varchar(10), f2 bigint);" >>${REL_PATH}/varchar_alter.sql
16 echo "echo alter table t1 rename column f1 to F1;" >>${REL_PATH}/varchar_alter.sql
17 echo "alter table t1 rename column f1 to F1;" >>${REL_PATH}/varchar_alter.sql
18 echo "echo rename table t1 to T1;" >>${REL_PATH}/varchar_alter.sql
19 echo "rename table t1 to T1;" >>${REL_PATH}/varchar_alter.sql
20 echo "echo show tables;" >>${REL_PATH}/varchar_alter.sql
21 echo "show tables;" >>${REL_PATH}/varchar_alter.sql
23 echo "drop table T1;" >${REL_PATH}/dropT1.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropT1.sql
>/dev
/null
2>&1
27 if [ "$VALGRIND" = "true" ]
29 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_alter.sql
31 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/varchar_alter.sql
34 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropT1.sql
35 rm -f ${REL_PATH}/varchar_alter.sql
${REL_PATH}/dropT1.sql
40 if [ "$VALGRIND" = "true" ]
42 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
44 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-l
47 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropT1.sql
53 rm -f ${REL_PATH}/varchar_alter.sql
${REL_PATH}/dropT1.sql