3 # check used and free transacation slots in transaction table
6 # insert 1 tuple in 1 transaction and abort
8 # check used and free transacation slots in transaction table
10 #Run this test only under csql/test or on this directory.
11 #Otherwise, it may fail
12 EXECUTABLE
=${PWD}/system
/trans
/create
14 if [ -s "$EXECUTABLE" ]
16 REL_PATH
=${PWD}/system
/trans
18 if [ $VALGRIND = "true" ]
20 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/create
2> $0.valgr
25 echo "create table failed"
29 echo "Case 1: -d option with no transactions"
30 if [ $VALGRIND = "true" ]
32 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D trans
2>> $0.valgr
34 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D trans
42 while [ ${count} -gt 0 ]
44 count
=`expr ${count} - 1`
45 if [ $VALGRIND = "true" ]
47 valgrind
--tool=memcheck
--leak-check=full
${REL_PATH}/insert1andAbort
2>> $0.valgr
49 ${REL_PATH}/insert1andAbort
>/tmp
/tstlog
57 echo "Case 2: -d option after 120 aborts"
58 if [ $VALGRIND = "true" ]
60 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D trans
2>> $0.valgr
62 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D trans
71 echo "drop table failed"