test/tools/csql/test124.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # Create table t1 having two integer field f1 ,f2 with primary key f1 . create table t2 having two integer field f3,f4 with primary key f3 . and create table t3 having two integer field f5,f6 with foreign key f5 refers t1 (f1) and foreign key f6 refers t2 (f3)..It Should be passed. Test all valid and invalid DML Operation Related to Foreign Key
   4 #
   5 QUITFILE=${PWD}/tools/csql/quit.sql
   6 REL_PATH=.
   7 if [ -s "$QUITFILE" ]
   8 then
   9     REL_PATH=`pwd`/tools/csql
  10 fi
  11
  12 echo "drop table t3;" >${REL_PATH}/drp1.sql
  13 echo "drop table t2;" >>${REL_PATH}/drp1.sql
  14 echo "drop table t1;" >>${REL_PATH}/drp1.sql
  15
  16 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/foreign7.sql
  17 if [ $? -ne 0 ]
  18 then
  19    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
  20    rm -f ${REL_PATH}/drp1.sql
  21    exit 1;
  22 fi
  23
  24 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
  25 if [ $? -ne 0 ]
  26 then
  27    rm -f ${REL_PATH}/drp1.sql
  28    exit 3;
  29 fi
  30
  31 rm -f ${REL_PATH}/drp1.sql
  32 exit 0;