test/sql/Join/test008.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 or t1.f1 >100
   6
   7 # AUTHOR : Jitendra Lenka
   8
   9 QUITFILE=${PWD}/sql/Join/quit.sql
  10 REL_PATH=.
  11 if [ -s "$QUITFILE" ]
  12 then
  13  REL_PATH=`pwd`/sql/Join
  14 fi
  15
  16 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/createt1t2t3.sql > /dev/null 2>&1
  17 if [ $? -ne 0 ]
  18  then
  19    exit 1;
  20  fi
  21
  22 echo "select t1.f1, t2.f1, t3.f1 from t1,t2,t3 where t1.f2= t2.f2 or t1.f1 >100:"
  23 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join11.sql
  24  if [ $? -ne 0 ]
  25    then
  26  $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2t3.sql > /dev/null 2>&1
  27  exit 4;
  28  fi
  29
  30
  31   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2t3.sql > /dev/null 2>&1
  32   exit 0;
  33