test/tools/catalog/test003.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # create table t1 (f1, f2) , index t1idx1 on t1(f1), index t1idx2 on t1(f2)
   4 # create table t2 (f1, f2) , index t2idx1 on t2(f1)
   5 # Check -T option with table having 1 index
   6 # Check -T option with table having 2 index
   7 # Check -I option on index t1idx2
   8 # drop tables t1 and t2
   9
  10 #Run this test only under csql/test or on this directory.
  11 #Otherwise, it may fail
  12 EXECUTABLE=${PWD}/tools/catalog/create
  13 REL_PATH=.
  14 if [ -s "$EXECUTABLE" ]
  15 then
  16     REL_PATH=${PWD}/tools/catalog
  17 fi
  18
  19 if [ "$VALGRIND" = "true" ]
  20 then
  21     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/create 2> $0.valgr
  22 else
  23     ${REL_PATH}/create
  24     if [ $? -ne 0 ]
  25     then
  26        exit 1;
  27     fi
  28 fi
  29
  30 echo "Tables and Indexes are created"
  31 echo "Case 1: -T option for t1: with two index"
  32 if [ "$VALGRIND" = "true" ]
  33 then
  34     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1 2>> $0.valgr
  35 else
  36     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1
  37     if [ $? -ne 0 ]
  38     then
  39        exit 2;
  40     fi
  41 fi
  42
  43 echo "Case 2: -T option for t2: with one index"
  44 if [ "$VALGRIND" = "true" ]
  45 then
  46     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t2 2>> $0.valgr
  47 else
  48     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t2
  49     if [ $? -ne 0 ]
  50     then
  51        exit 3;
  52     fi
  53 fi
  54
  55 echo "Case 3: -I option for idx2 of t1"
  56 if [ "$VALGRIND" = "true" ]
  57 then
  58     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I t1idx2 2>> $0.valgr
  59 else
  60     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I t1idx2
  61     if [ $? -ne 0 ]
  62     then
  63        exit 4;
  64     fi
  65 fi
  66
  67 if [ "$VALGRIND" = "true" ]
  68 then
  69     valgrind --tool=memcheck --leak-check=full ${REL_PATH}/drop 2>> $0.valgr
  70 else
  71     ${REL_PATH}/drop
  72     if [ $? -ne 0 ]
  73     then
  74        exit 5;
  75     fi
  76 fi
  77 echo "Tables and Indexes are dropped"
  78
  79 exit 0