test/tools/catalog/test008.ksh

   1 #!/bin/ksh
   2 # Test Case for compact table t1 to compact memory
   3 # check options -d
   4 #
   5 #
   6
   7 CSQL_CONF=${PWD}/tools/catalog/csql.conf
   8 input=${PWD}/tools/catalog/create.sql
   9 REL_PATH=.
  10 if [ -s "$input" -a -s "$CSQL_CONF" ]
  11 then
  12     REL_PATH=${PWD}/tools/catalog
  13 fi
  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
  17 a=1
  18 while [[ $a -lt 5000 ]];do
  19     echo "insert into t1 values($a,$a,'lakshyacsql');"
  20     if [ $a -eq 500 ]
  21     then
  22         echo "commit;">>$REL_PATH/createlargedata.sql
  23     fi
  24     (( a +=1 ))
  25 done >> $REL_PATH/createlargedata.sql
  26
  27 echo "delete from t1 where f1<4000;" >$REL_PATH/deletelarge.sql
  28 echo "commit;">>$REL_PATH/deletelarge.sql
  29
  30
  31 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  32 pid=$!
  33 sleep 10
  34
  35 echo "Case 1: With -d option before table creation:"
  36 echo "============================================"
  37 if [ "$VALGRIND" = "true" ]
  38 then
  39     valgrind --tool=memcheck --leak-check=full  $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d 2> $0.valgr
  40 else
  41     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  42     if [ $? -ne 0 ]
  43     then
  44        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql
  45        kill -9 $pid
  46        ipcrm -M 1199 -M 2277
  47        exit 1;
  48     fi
  49 fi
  50
  51 if [ "$VALGRIND" = "true" ]
  52 then
  53     valgrind --tool=memcheck --leak-check=full  $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/createlargedata.sql 2>> $0.valgr
  54 else
  55     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/createlargedata.sql >/dev/null 2>&1
  56     if [ $? -ne 0 ]
  57     then
  58        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql
  59        kill -9 $pid
  60        ipcrm -M 1199 -M 2277
  61        exit 2;
  62     fi
  63 fi
  64
  65 echo "Case 2: With -D chunk option after table creation:"
  66 echo "============================================"
  67 if [ "$VALGRIND" = "true" ]
  68 then
  69     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
  70 else
  71     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  72     if [ $? -ne 0 ]
  73     then
  74        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql
  75        kill -9 $pid
  76        ipcrm -M 1199 -M 2277
  77        exit 3;
  78     fi
  79 fi
  80
  81 if [ "$VALGRIND" = "true" ]
  82 then
  83     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -U -s ${REL_PATH}/deletelarge.sql 2>> $0.valgr
  84 else
  85     $CSQL_INSTALL_ROOT/bin/csql -U -s ${REL_PATH}/deletelarge.sql
  86     if [ $? -ne 0 ]
  87     then
  88        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql
  89        kill -9 $pid
  90        ipcrm -M 1199 -M 2277
  91        exit 4;
  92     fi
  93 fi
  94
  95 echo "Case 3: With -D chunk  option after record deleted:"
  96 echo "==================================================="
  97 if [ "$VALGRIND" = "true" ]
  98 then
  99     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
 100 else
 101     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
 102     if [ $? -ne 0 ]
 103     then
 104        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql
 105        kill -9 $pid
 106        ipcrm -M 1199 -M 2277
 107        exit 5;
 108     fi
 109 fi
 110 echo "compact table t1;" >${REL_PATH}/compact.sql
 111
 112 if [ "$VALGRIND" = "true" ]
 113 then
 114     valgrind --tool=memcheck --leak-check=full  $CSQL_INSTALL_ROOT/bin/csql -U -s ${REL_PATH}/compact.sql 2>> $0.valgr
 115 else
 116     $CSQL_INSTALL_ROOT/bin/csql -U -s ${REL_PATH}/compact.sql
 117     if [ $? -ne 0 ]
 118     then
 119        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql ${REL_PATH}/compact.sql
 120        kill -9 $pid
 121        ipcrm -M 1199 -M 2277
 122        exit 4;
 123     fi
 124 fi
 125
 126 echo "Case 4: With -D chunk  option after compact statement :"
 127 echo "======================================="
 128 if [ "$VALGRIND" = "true" ]
 129 then
 130     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
 131 else
 132     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
 133     if [ $? -ne 0 ]
 134     then
 135        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql ${REL_PATH}/compact.sql
 136        kill -9 $pid
 137        ipcrm -M 1199 -M 2277
 138        exit 7;
 139     fi
 140 fi
 141
 142 if [ "$VALGRIND" = "true" ]
 143 then
 144     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/dropt1.sql 2>> $0.valgr
 145 else
 146     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/dropt1.sql
 147     if [ $? -ne 0 ]
 148     then
 149        rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql ${REL_PATH}/compact.sql
 150        kill -9 $pid
 151        ipcrm -M 1199 -M 2277
 152        exit 8;
 153     fi
 154 fi
 155
 156 rm -f $REL_PATH/createlargedata.sql $REL_PATH/deletelarge.sql ${REL_PATH}/compact.sql
 157 kill -9 $pid
 158 ipcrm -M 1199 -M 2277
 159 exit 0;
 160