*** empty log message ***
[csql.git] / test / tools / csql / test110.ksh
blob6b3f0cbbae91b196584d9d85af9b293cbae715f9
1 #!/bin/sh
2 # Test Case
3 # Create table t1 having two integer field f1 ,f2 with primary key f1 and create table t2 having two integer field f1,f2 with foreign key f1 refers t1 (f1). Insert some record into t1 and insert record into t2 with same value as existing PK table key field. Delete record from t2 then delete from t1. it should pass.
5 QUITFILE=${PWD}/tools/csql/quit.sql
6 REL_PATH=.
7 if [ -s "$QUITFILE" ]
8 then
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}/delete_child_parent.sql
16 if [ $? -ne 0 ]
17 then
18 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
19 rm -f ${REL_PATH}/drp1.sql
20 exit 1;
23 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
24 if [ $? -ne 0 ]
25 then
26 rm -f ${REL_PATH}/drp1.sql
27 exit 2;
30 rm -f ${REL_PATH}/drp1.sql
31 exit 0;