3 # 1. create table t1 (f1 int not null, f2 int);
4 # 2. create index idx on t1 (f1) tree unique
5 # 3. insert duplicate records and it should fail
7 QUITFILE
=${PWD}/tools
/csql
/quit.sql
11 REL_PATH
=`pwd`/tools
/csql
13 #table creation and insertino of 50 records
14 if [ "$VALGRIND" = "true" ]
16 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/tree2.sql
2> $0.valgr
18 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/tree2.sql
25 if [ "$VALGRIND" = "true" ]
27 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selectstar.sql
2>> $0.valgr
29 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selectstar.sql
35 echo "50 rows selected";
37 #selecting rows providing condition
38 if [ "$VALGRIND" = "true" ]
40 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selcond.sql
2>> $0.valgr
42 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/selcond.sql
49 if [ "$VALGRIND" = "true" ]
51 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
2>> $0.valgr
53 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql