test/tools/csql/test117.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). It should pass.
   4 # This case also tests field name( Means FK field name may or may not be same as PK field name.)
   5 #
   6 QUITFILE=${PWD}/tools/csql/quit.sql
   7 REL_PATH=.
   8 if [ -s "$QUITFILE" ]
   9 then
  10     REL_PATH=`pwd`/tools/csql
  11 fi
  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}/fieldname_fk_pk.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 2;
  29 fi
  30
  31 rm -f ${REL_PATH}/drp1.sql
  32 exit 0;