test/sql/Join/test004.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # 5.
   4 #       Testing or, and operators in join.
   5 #       Create t1,t2,t3 table with 5 records each.
   6 #       select * from t1,t2,t3 where t1.f2= t2.f2 and t1.f3 = t3.f2.
   7 #       select * from t1,t2,t3 where t1.f2= t2.f2 or t1.f3 = t3.f2.
   8
   9 # AUTHOR : Jitendra Lenka
  10
  11 QUITFILE=${PWD}/sql/Join/quit.sql
  12 REL_PATH=.
  13 if [ -s "$QUITFILE" ]
  14  then
  15 REL_PATH=`pwd`/sql/Join
  16 fi
  17
  18
  19 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/createt1t2t3.sql > /dev/null 2>&1
  20 if [ $? -ne 0 ]
  21 then
  22   exit 1;
  23 fi
  24
  25 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join4.sql
  26 if [ $? -ne 0 ]
  27 then
  28   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2t3.sql > /dev/null 2>&1
  29   exit 2;
  30 fi
  31
  32
  33 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2t3.sql > /dev/null 2>&1
  34 exit 0;
  35