test/tools/catalog/test002.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # check options l, i, d, T, I with empty database
   4 # check options D with trans, lock and non existing structure name
   5 # check behaviour when multiple options are given together
   6
   7 echo "Case 1: With l option:"
   8 if [ "$VALGRIND" = "true" ]
   9 then
  10     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l 2> $0.valgr
  11 else
  12     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  13     if [ $? -ne 0 ]
  14     then
  15        exit 1;
  16     fi
  17 fi
  18 echo "Case 2: With i option:"
  19 if [ "$VALGRIND" = "true" ]
  20 then
  21     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -i 2>> $0.valgr
  22 else
  23     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -i
  24     if [ $? -ne 0 ]
  25     then
  26        exit 2;
  27     fi
  28 fi
  29
  30 echo "Case 3: With d option:"
  31 if [ "$VALGRIND" = "true" ]
  32 then
  33     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d 2>> $0.valgr
  34 else
  35     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  36     if [ $? -ne 0 ]
  37     then
  38        exit 3;
  39     fi
  40 fi
  41
  42 echo "Case 4: With nonexisting tablename on -T option :"
  43 if [ "$VALGRIND" = "true" ]
  44 then
  45     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1 2>> $0.valgr
  46 else
  47     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -T t1 2>/tmp/tmptstlog
  48     if [ $? -eq 0 ]
  49     then
  50        exit 4;
  51     fi
  52 fi
  53
  54 echo "Case 5: With nonexisting indexname on -I option :"
  55 if [ "$VALGRIND" = "true" ]
  56 then
  57     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I idx1 2>> $0.valgr
  58 else
  59     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -I idx1 2>/tmp/tmptstlog
  60     if [ $? -eq 0 ]
  61     then
  62        exit 5;
  63     fi
  64 fi
  65
  66 echo "Case 6: With trans on D option:"
  67 if [ "$VALGRIND" = "true" ]
  68 then
  69     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D trans 2>> $0.valgr
  70 else
  71     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D trans
  72     if [ $? -ne 0 ]
  73     then
  74        exit 6;
  75     fi
  76 fi
  77 echo "Case 7: With lock on D option:"
  78 if [ "$VALGRIND" = "true" ]
  79 then
  80     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D lock 2>> $0.valgr
  81 else
  82     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D lock
  83     if [ $? -ne 0 ]
  84     then
  85        exit 7;
  86     fi
  87 fi
  88 echo "Case 8: With nonexisting structure on D option:"
  89 if [ "$VALGRIND" = "true" ]
  90 then
  91     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D notexist 2>> $0.valgr
  92 else
  93     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D notexist
  94     if [ $? -eq 0 ]
  95     then
  96        exit 8;
  97     fi
  98 fi
  99 echo "Case 9: With two options:"
 100 if [ "$VALGRIND" = "true" ]
 101 then
 102     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d -l 2>> $0.valgr
 103 else
 104     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d -l
 105     if [ $? -ne 0 ]
 106     then
 107        exit 9;
 108     fi
 109 fi
 110 exit 0