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