*** empty log message ***
[csql.git] / test / tools / csql / test107.ksh
blobeee3f301e325bdbca8972545b05ac024a0edcde5
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 t2 .It should fail to insert record as PK table has no record.
5 QUITFILE=${PWD}/tools/csql/quit.sql
6 REL_PATH=.
7 if [ -s "$QUITFILE" ]
8 then
9 REL_PATH=`pwd`/tools/csql
13 echo "drop table t2;" >${REL_PATH}/drp1.sql
14 echo "drop table t1;" >>${REL_PATH}/drp1.sql
16 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insertat_child_wthout_parent.sql
17 if [ $? -ne 0 ]
18 then
19 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
20 rm -f ${REL_PATH}/drp1.sql
21 exit 1;
24 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drp1.sql
25 if [ $? -ne 0 ]
26 then
27 rm -f ${REL_PATH}/drp1.sql
28 exit 2;
31 rm -f ${REL_PATH}/drp1.sql
32 exit 0;