2 # Create table t1 having two integer field f1 ,f2 with primary key f1 . create table t2 having two integer field f3,f4 with primary key f3 . and create table t3 having two integer field f5,f6 with foreign key f5 refers t1 (f1) and foreign key f6 refers t2 (f3)..It Should be passed. Test all valid and invalid DML Operation Related to Foreign Key.use csqldump toll for dumping the foreign key information.
4 input
=${PWD}/tools
/csqldump
/foreign5.sql
8 REL_PATH
=${PWD}/tools
/csqldump
11 echo "DROP TABLE t3;" >$REL_PATH/drp1.sql
12 echo "DROP TABLE t2;" >>$REL_PATH/drp1.sql
13 echo "DROP TABLE t1;" >>$REL_PATH/drp1.sql
15 if [ "$VALGRIND" = "true" ]
17 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/foreign5.sql
2> $0.valgr
19 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/foreign5.sql
>/dev
/null
2>&1
22 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
> /dev
/null
2>&1
23 rm -f $REL_PATH/drp1.sql
28 if [ "$VALGRIND" = "true" ]
30 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
32 $CSQL_INSTALL_ROOT/bin
/csqldump
35 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
> /dev
/null
2>&1
36 rm -f $REL_PATH/drp1.sql
41 if [ "$VALGRIND" = "true" ]
43 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
2>> $0.valgr
45 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
> /dev
/null
2>&1
49 rm -f $REL_PATH/drp1.sql
53 rm -f $REL_PATH/drp1.sql