3 # Create table t1 having two integer field f1 ,f2 with primary key f1 and create table t2 having two integer field f1 NOT NULL,f2 with foreign key f1 refers t1 (f1). Apply unique hash index on t2(f1). It should pass.
5 QUITFILE
=${PWD}/tools
/csql
/quit.sql
9 REL_PATH
=`pwd`/tools
/csql
12 echo "drop table t2;" >${REL_PATH}/drp1.sql
13 echo "drop table t1;" >>${REL_PATH}/drp1.sql
15 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/foreign9.sql
18 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drp1.sql
19 rm -f ${REL_PATH}/drp1.sql
23 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drp1.sql
26 rm -f ${REL_PATH}/drp1.sql
30 rm -f ${REL_PATH}/drp1.sql