test/tools/csqldump/test011.ksh

   1 #!/bin/ksh
   2
   3 #Run this test only under csql/test or on this directory.
   4 #Otherwise, it may fail
   5
   6
   7
   8 input=${PWD}/tools/csqldump/inputtest008.sql
   9 REL_PATH=.
  10 if [ -s "$input" ]
  11 then
  12     REL_PATH=${PWD}/tools/csqldump
  13 fi
  14
  15 if [ "$VALGRIND" = "true" ]
  16 then
  17     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/inputtest008.sql 2> $0.valgr
  18 else
  19     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/inputtest008.sql >/dev/null 2>&1
  20     if [ $? -ne 0 ]
  21     then
  22         exit 1;
  23     fi
  24 fi
  25
  26 if [ "$VALGRIND" = "true" ]
  27 then
  28     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump -n 3 -T vikas 2>> $0.valgr
  29 else
  30     $CSQL_INSTALL_ROOT/bin/csqldump -n 3 -T vikas
  31     if [ $? -ne 0 ]
  32     then
  33         exit 2;
  34     fi
  35 fi
  36
  37 if [ "$VALGRIND" = "true" ]
  38 then
  39     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/dropall.sql 2>> $0.valgr
  40 else
  41     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/dropall.sql > /dev/null 2>&1
  42     if [ $? -ne 0 ]
  43     then
  44         exit 3;
  45     fi
  46 fi
  47
  48 exit 0;