test/tools/catalog/test007.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # create table t4(f1, f2) primary key on f1
   4 # create table t5 (f1, f2) , primary key on (f1,f2)
   5 # Check -l option on primary flag of the key
   6 # drop tables
   7
   8 #Run this test only under csql/test or on this directory.
   9 #Otherwise, it may fail
  10 REL_PATH=.
  11
  12 CSQL_CONF=${PWD}/tools/catalog/csql.conf
  13 input=${PWD}/tools/catalog/create.sql
  14 REL_PATH=.
  15 if [ -s "$input" -a -s "$CSQL_CONF" ]
  16 then
  17     REL_PATH=${PWD}/tools/catalog
  18 fi
  19 export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
  20
  21 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  22 pid=$!
  23 sleep 5
  24 echo "Case 1: create two table t4,t5 "
  25 if [ "$VALGRIND" = "true" ]
  26 then
  27     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/createPriFlagTest.sql 2> $0.valgr
  28 else
  29     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/createPriFlagTest.sql
  30     if [ $? -ne 0 ]
  31     then
  32        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt4t5.sql
  33        exit 1;
  34     fi
  35 fi
  36
  37 echo "Case 2: With -l option after for primary flag checking:"
  38 if [ "$VALGRIND" = "true" ]
  39 then
  40     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l 2>> $0.valgr
  41 else
  42     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  43     if [ $? -ne 0 ]
  44     then
  45        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt4t5.sql
  46        exit 2;
  47     fi
  48 fi
  49 echo "case 3 : drop two table "
  50
  51 if [ "$VALGRIND" = "true" ]
  52 then
  53     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt4t5.sql 2>> $0.valgr
  54 else
  55     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt4t5.sql
  56     if [ $? -ne 0 ]
  57     then
  58        exit 3;
  59     fi
  60 fi
  61 echo "t4 ,t5 table droped "
  62 kill -9 $pid
  63 ipcrm -M 1199 -M 2277
  64
  65 exit 0