3 # Create table t1 having two integer field f1 ,f2 and create table t2 having two integer field f1,f2 with foreign key f1 refers t1 (f1). It should fail due to primary table referring field do not have key field
5 QUITFILE
=${PWD}/tools
/csql
/quit.sql
9 REL_PATH
=`pwd`/tools
/csql
13 echo "CREATE TABLE t1(f1 INT,f2 INT);" >${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
18 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/fkey1.sql
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
28 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/fkey2.sql
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
40 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drp1.sql
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
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