test/tools/csql/test143.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 foreign key f3 refers t1 (f1) and a primary key f4
   4 # create table t3 having two integer field f5,f6 with foreign key f5 refers t2 (f4).It Should be passed.
   5 #
   6
   7 QUITFILE=${PWD}/tools/csql/quit.sql
   8 REL_PATH=.
   9 if [ -s "$QUITFILE" ]
  10 then
  11     REL_PATH=`pwd`/tools/csql
  12 fi
  13
  14 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/foreign143.ksh
  15 if [ $? -ne 0 ]
  16 then
  17    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t3_t2_t1.sql
  18    rm -f ${REL_PATH}/drp1.sql
  19    exit 1;
  20 fi
  21
  22 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t3_t2_t1.sql
  23 if [ $? -ne 0 ]
  24 then
  25    exit 3;
  26 fi
  27
  28 exit 0;