test/tools/csqldump/test015.ksh

   1 #!/bin/ksh
   2 # Create table t1 having two integer field f1 ,f2 with primary key f1 and create table t2 having two integer field f1,f2 with foreign key f1 refers t1 (f1). drop FK table. then drop PK table. It should pass. use csqldump toll for dumping the foreign key information. It Should not display any information.
   3 #
   4 input=${PWD}/tools/csqldump/foreign2.sql
   5 REL_PATH=.
   6 if [ -s "$input" ]
   7 then
   8     REL_PATH=${PWD}/tools/csqldump
   9 fi
  10
  11 echo "DROP TABLE t2;" >$REL_PATH/drp1.sql
  12 echo "DROP TABLE t1;" >>$REL_PATH/drp1.sql
  13
  14 if [ "$VALGRIND" = "true" ]
  15 then
  16     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/foreign2.sql 2> $0.valgr
  17 else
  18     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/foreign2.sql >/dev/null 2>&1
  19     if [ $? -ne 0 ]
  20     then
  21         $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql > /dev/null 2>&1
  22         rm -f $REL_PATH/drp1.sql
  23         exit 1;
  24     fi
  25 fi
  26
  27 if [ "$VALGRIND" = "true" ]
  28 then
  29     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
  30 else
  31     $CSQL_INSTALL_ROOT/bin/csqldump
  32     if [ $? -ne 0 ]
  33     then
  34         $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql > /dev/null 2>&1
  35         rm -f $REL_PATH/drp1.sql
  36         exit 2;
  37     fi
  38 fi
  39
  40 if [ "$VALGRIND" = "true" ]
  41 then
  42     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql 2>> $0.valgr
  43 else
  44     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s $REL_PATH/drp1.sql > /dev/null 2>&1
  45     if [ $? -ne 0 ]
  46     then
  47         rm -f $REL_PATH/drp1.sql
  48         exit 3;
  49     fi
  50 fi
  51
  52 rm -f $REL_PATH/drp1.sql
  53 exit 0;