test/tools/csql/test122.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # Create table t1 having three integer field f1 ,f2,f3 with composite primary key (f1,f2) and create table t2 having three integer field f1,f2,f3 with foreign key (f1,f3) refers t1 (f1,f2).nsert some record into t1 and insert record into t2 with same value as existing PK table key field. Update on Foreign Key field of FK table should check PK table is record exist or not. If not exist,Update should fail.
   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}/foreign5.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;