3 #create table t1( f1 int not null,f2 int, f3 int);
4 #a) create tree unique index on first field
5 #b) create tree primary index on same firld.
6 #It should be failed Saying "Index on this field already exists".
8 QUITFILE
=${PWD}/tools
/csql
/quit.sql
12 REL_PATH
=`pwd`/tools
/csql
15 if [ "$VALGRIND" = "true" ]
17 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/tree17.sql
2> $0.valgr
19 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/tree17.sql
26 if [ "$VALGRIND" = "true" ]
28 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
-T t1
2>> $0.valgr
30 $CSQL_INSTALL_ROOT/bin
/csqldump
-T t1
33 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql