test/sql/Join/test005.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # 5.
   4 #       Create t1,t2,t3 table with 5 each records in csql database.
   5 #       select t1.f1, t2.f1, t3.f1 from t1,t2,t3 where t1.f2= t2.f2 and t1.f3 = t3.f2
   6 #       select t1.f1, t2.f1, t3.f1 from t1,t2,t3 where t1.f2= t2.f2 or t1.f3 = t3.f2
   7 #       select t1.f1, t2.f1, t3.f1 from t1,t2,t3 where t1.f2= t2.f2 or t1.f1 >100
   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 echo "select t1.f1, t2.f1, t3.f1 from t1,t2,t3 where t1.f2= t2.f2 and t1.f3 = t3.f2:"
  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/join9.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 echo "select t1.f1, t2.f1, t3.f1 from t1,t2,t3 where t1.f2= t2.f2 or t1.f3 = t3.f2:"
  33
  34 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join10.sql
  35 if [ $? -ne 0 ]
  36  then
  37   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2t3.sql > /dev/null 2>&1
  38   exit 3;
  39  fi
  40
  41
  42
  43   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2t3.sql > /dev/null 2>&1
  44   exit 0;
  45