test/tools/catalog/test005.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # check options -D chunk with empty database
   4 #create table t1 (f1,f2) check with -D chunk
   5 #drop t1  check with -D chunk
   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
  16 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  17 pid=$!
  18 sleep 10
  19 echo "Case 1: With -D chunk option with empty database"
  20 if [ "$VALGRIND" = "true" ]
  21 then
  22     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2> $0.valgr
  23 else
  24     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  25     if [ $? -ne 0 ]
  26     then
  27        exit 1;
  28     fi
  29 fi
  30 if [ "$VALGRIND" = "true" ]
  31 then
  32     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/create.sql 2>> $0.valgr
  33 else
  34     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/create.sql
  35     if [ $? -ne 0 ]
  36     then
  37        exit 2;
  38     fi
  39 fi
  40
  41 echo "Case 2: With -D chunk  option after table creation:"
  42 if [ "$VALGRIND" = "true" ]
  43 then
  44     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
  45 else
  46     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  47     if [ $? -ne 0 ]
  48     then
  49        exit 3;
  50     fi
  51 fi
  52
  53 if [ "$VALGRIND" = "true" ]
  54 then
  55     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/dropt1.sql 2>> $0.valgr
  56 else
  57     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/dropt1.sql
  58     if [ $? -ne 0 ]
  59     then
  60        exit 4;
  61     fi
  62 fi
  63 echo "t1 table droped "
  64
  65 echo "Case 3: With -D chunk  option after drop t1 :"
  66 if [ "$VALGRIND" = "true" ]
  67 then
  68     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
  69 else
  70     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  71     if [ $? -ne 0 ]
  72     then
  73        exit 5;
  74     fi
  75 fi
  76
  77 kill -9 $pid
  78 ipcrm -M 1199 -M 2277
  79 exit 0;
  80