test/tools/csql/test145.ksh

   1 #!/bin/sh
   2 # Create table t1 having two integer field f1 ,f2 with primary key f1 .
   3 # Create table t2 having two integer field f3,f4 with primary key f3 .
   4 # Create table t3 having two integer field f5,f6 with foreign key f5 refers t1 (f1) and foreign key f6 refers t2 (f3).
   5 # Drop table t2. It should be failed. because child t3 is exist.
   6 #
   7
   8 QUITFILE=${PWD}/tools/csql/quit.sql
   9 REL_PATH=.
  10 if [ -s "$QUITFILE" ]
  11 then
  12     REL_PATH=`pwd`/tools/csql
  13 fi
  14
  15 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/foreign145.sql
  16 if [ $? -ne 0 ]
  17 then
  18    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t3_t2_t1.sql
  19    rm -f ${REL_PATH}/drp1.sql
  20    exit 1;
  21 fi
  22
  23 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t3_t2_t1.sql
  24 if [ $? -ne 0 ]
  25 then
  26    exit 3;
  27 fi
  28
  29 exit 0;