test/tools/catalog/test006.ksh

   1 #!/bin/sh
   2 # Test Case
   3 #create table t2 (f1,f2,f3) ,with primary key(f1) and index on f3 .check with -D chunk
   4 #insert 20 tuples and check with -D chunk
   5 #delete 10 tuples and check with -D chunk
   6 #drop t2 check with -D chunk
   7
   8 CSQL_CONF=${PWD}/tools/catalog/csql.conf
   9 input=${PWD}/tools/catalog/create.sql
  10 REL_PATH=.
  11 if [ -s "$input" -a -s "$CSQL_CONF" ]
  12 then
  13     REL_PATH=${PWD}/tools/catalog
  14 fi
  15 export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
  16
  17 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  18 pid=$!
  19 sleep 5
  20
  21 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/create1.sql
  22 if [ $? -ne 0 ]
  23 then
  24    exit 1;
  25 fi
  26 echo "Table  created"
  27
  28 echo "Case 1: With -D chunk  option after table creation:"
  29 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  30 if [ $? -ne 0 ]
  31 then
  32    exit 2;
  33 fi
  34 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/insert.sql
  35 if [ $? -ne 0 ]
  36 then
  37    exit 3;
  38 fi
  39 echo "Tuples insered"
  40 echo "Case 2: With -D chunk  option after insert 20 tuples:"
  41 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  42 if [ $? -ne 0 ]
  43 then
  44    exit 4;
  45 fi
  46 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/delete.sql
  47 if [ $? -ne 0 ]
  48 then
  49    exit 5;
  50 fi
  51
  52 echo "10 tuples deleted"
  53
  54 echo "Case 3: With -D chunk option after deleting 10 tuples :"
  55 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  56 if [ $? -ne 0 ]
  57 then
  58    exit 6;
  59 fi
  60 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/dropIndex.sql
  61 if [ $? -ne 0 ]
  62 then
  63    exit 7;
  64 fi
  65 echo "Index droped"
  66
  67 echo "Case 4: With -D chunk  option after Index droped :"
  68 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  69 if [ $? -ne 0 ]
  70 then
  71    exit 8;
  72 fi;
  73
  74 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/dropt2.sql
  75
  76 if [ $? -ne 0 ]
  77 then
  78    exit 9;
  79 fi
  80 echo "t2 table droped with index"
  81
  82 echo "Case 5: With -D chunk  option after drop t2 :"
  83 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  84 if [ $? -ne 0 ]
  85 then
  86    exit 10;
  87 fi
  88
  89 kill -9 $pid
  90 ipcrm -M 1199 -M 2277
  91 exit 0;