test/tools/csql/test106.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # Create table t1 having two field f1 char and f2 int with primary key f1 and create table t2 having two field f1 char and f2 int with foreign key f1 refers t1 (f1). It should pass.
   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
  13 echo "CREATE TABLE t1(f1 CHAR(10),f2 INT, PRIMARY KEY(f1));" >${REL_PATH}/fkey1.sql
  14 echo "CREATE TABLE t2(f1 CHAR(10),f2 INT,FOREIGN KEY(f1) REFERENCES t1(f1));" >${REL_PATH}/fkey2.sql
  15 echo "drop table t2;" >${REL_PATH}/drp1.sql
  16 echo "drop table t1;" >>${REL_PATH}/drp1.sql
  17
  18 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/fkey1.sql
  19 if [ $? -ne 0 ]
  20 then
  21    rm -f ${REL_PATH}/fkey1.sql
  22    rm -f ${REL_PATH}/fkey2.sql
  23    rm -f ${REL_PATH}/drp1.sql
  24    exit 1;
  25 fi
  26
  27 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/fkey2.sql
  28 if [ $? -ne 0 ]
  29 then
  30    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
  31    rm -f ${REL_PATH}/fkey1.sql
  32    rm -f ${REL_PATH}/fkey2.sql
  33    rm -f ${REL_PATH}/drp1.sql
  34    exit 2;
  35 fi
  36
  37 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
  38 if [ $? -ne 0 ]
  39 then
  40    rm -f ${REL_PATH}/fkey1.sql
  41    rm -f ${REL_PATH}/fkey2.sql
  42    rm -f ${REL_PATH}/drp1.sql
  43    exit 3;
  44 fi
  45
  46 rm -f ${REL_PATH}/fkey1.sql
  47 rm -f ${REL_PATH}/fkey2.sql
  48 rm -f ${REL_PATH}/drp1.sql
  49 exit 0;