2 # Test Case for compact table t1 to compact memory
7 CSQL_CONF
=${PWD}/tools
/catalog
/csql.conf
8 input
=${PWD}/tools
/catalog
/create.sql
10 if [ -s "$input" -a -s "$CSQL_CONF" ]
12 REL_PATH
=${PWD}/tools
/catalog
14 export CSQL_CONFIG_FILE
=$REL_PATH/csql.conf
15 echo "create table t1(f1 int,f2 int,f3 char(2000),primary key(f1));">$REL_PATH/createlargedata.sql
16 echo "create index t1treeind on t1(f2) tree;">>$REL_PATH/createlargedata.sql
18 while [[ $a -lt 5000 ]];do
19 echo "insert into t1 values($a,$a,'lakshyacsql');"
22 echo "commit;">>$REL_PATH/createlargedata.sql
25 done >> $REL_PATH/createlargedata.sql
27 echo "delete from t1 where f1<4000;" >$REL_PATH/deletelarge.sql
28 echo "commit;">>$REL_PATH/deletelarge.sql
31 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
35 echo "Case 1: With -d option before table creation:"
36 echo "============================================"
37 if [ "$VALGRIND" = "true" ]
39 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-d 2> $0.valgr
41 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-d
44 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
51 if [ "$VALGRIND" = "true" ]
53 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/createlargedata.sql
2>> $0.valgr
55 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/createlargedata.sql
>/dev
/null
2>&1
58 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
65 echo "Case 2: With -D chunk option after table creation:"
66 echo "============================================"
67 if [ "$VALGRIND" = "true" ]
69 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D chunk
2>> $0.valgr
71 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D chunk
74 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
81 if [ "$VALGRIND" = "true" ]
83 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-U -s ${REL_PATH}/deletelarge.sql
2>> $0.valgr
85 $CSQL_INSTALL_ROOT/bin
/csql
-U -s ${REL_PATH}/deletelarge.sql
88 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
95 echo "Case 3: With -D chunk option after record deleted:"
96 echo "==================================================="
97 if [ "$VALGRIND" = "true" ]
99 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D chunk
2>> $0.valgr
101 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D chunk
104 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
106 ipcrm
-M 1199 -M 2277
110 echo "compact table t1;" >${REL_PATH}/compact.sql
112 if [ "$VALGRIND" = "true" ]
114 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-U -s ${REL_PATH}/compact.sql
2>> $0.valgr
116 $CSQL_INSTALL_ROOT/bin
/csql
-U -s ${REL_PATH}/compact.sql
119 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
${REL_PATH}/compact.sql
121 ipcrm
-M 1199 -M 2277
126 echo "Case 4: With -D chunk option after compact statement :"
127 echo "======================================="
128 if [ "$VALGRIND" = "true" ]
130 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D chunk
2>> $0.valgr
132 $CSQL_INSTALL_ROOT/bin
/catalog
-u root
-p manager
-D chunk
135 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
${REL_PATH}/compact.sql
137 ipcrm
-M 1199 -M 2277
142 if [ "$VALGRIND" = "true" ]
144 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/dropt1.sql
2>> $0.valgr
146 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/dropt1.sql
149 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
${REL_PATH}/compact.sql
151 ipcrm
-M 1199 -M 2277
156 rm -f $REL_PATH/createlargedata.sql
$REL_PATH/deletelarge.sql
${REL_PATH}/compact.sql
158 ipcrm
-M 1199 -M 2277