test/tools/csql/test105.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 integer field f1,f2 with foreign key f1 refers t1 (f1). It should fail due to type mismatch in FK and PK table
   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 INT,f2 INT,FOREIGN KEY(f1) REFERENCES t1(f1));" >${REL_PATH}/fkey2.sql
  15 echo "drop table t1;" >${REL_PATH}/drp1.sql
  16 echo "drop table t2;" >${REL_PATH}/drp2.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    rm -f ${REL_PATH}/drp2.sql
  25    exit 1;
  26 fi
  27
  28 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/fkey2.sql
  29 if [ $? -ne 0 ]
  30 then
  31    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
  32    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp2.sql
  33    rm -f ${REL_PATH}/fkey1.sql
  34    rm -f ${REL_PATH}/fkey2.sql
  35    rm -f ${REL_PATH}/drp1.sql
  36    rm -f ${REL_PATH}/drp2.sql
  37    exit 2;
  38 fi
  39
  40 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
  41 if [ $? -ne 0 ]
  42 then
  43    rm -f ${REL_PATH}/fkey1.sql
  44    rm -f ${REL_PATH}/fkey2.sql
  45    rm -f ${REL_PATH}/drp1.sql
  46    rm -f ${REL_PATH}/drp2.sql
  47    exit 3;
  48 fi
  49
  50 rm -f ${REL_PATH}/fkey1.sql
  51 rm -f ${REL_PATH}/fkey2.sql
  52 rm -f ${REL_PATH}/drp1.sql
  53 rm -f ${REL_PATH}/drp2.sql
  54 exit 0;