test/tools/csql/test125.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 no primary key exist. 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 failed.
   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 t2;" >${REL_PATH}/drp1.sql
  13 echo "drop table t1;" >>${REL_PATH}/drp1.sql
  14
  15 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/foreign8.sql
  16 if [ $? -ne 0 ]
  17 then
  18    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.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}/drp1.sql
  24 if [ $? -ne 0 ]
  25 then
  26    rm -f ${REL_PATH}/drp1.sql
  27    exit 3;
  28 fi
  29
  30 rm -f ${REL_PATH}/drp1.sql
  31 exit 0;