test/tools/csql/test114.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # 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.
   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
  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}/drop_fk_pk.sql
  17 if [ $? -ne 0 ]
  18 then
  19    exit 3;
  20 fi
  21
  22 rm -f ${REL_PATH}/drp1.sql
  23 exit 0;