test/sql/Join/test009.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # 11.   Create emp table with 5 fields & dept table with 3 fields and insert        3 records in it.
   4
   5 #       (a)select t11.f1,t11.f2,t13.f7,t13.f8 from t11,t13 where t11.f5=t13.f8;
   6 #       (b)select f1,f3,f7,f8 from t11,t13 where t11.f5=t13.f8;
   7 #       (c)select t11.f1,t11.f2,t12.f1,t12.f2 from t11,t12,t13 where t13.f8 > t11.f5;
   8 #       (d)select f1,f3,f7,f8 from t11,t13 where t13.f8 < t11.f5;
   9 #       (e)select f1,f3,f7,f8 from t11,t13 where f5 > f8;
  10
  11 # AUTHOR : Jitendra Lenka
  12
  13 QUITFILE=${PWD}/sql/Join/quit.sql
  14 REL_PATH=.
  15 if [ -s "$QUITFILE" ]
  16 then
  17  REL_PATH=`pwd`/sql/Join
  18 fi
  19
  20
  21 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/tablet11t13.sql > /dev/null 2>&1
  22 if [ $? -ne 0 ]
  23 then
  24   exit 1;
  25 fi
  26
  27
  28
  29 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join9.sql
  30 if [ $? -ne 0 ]
  31   then
  32      $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt11t13.sql > /dev/null 2>&1
  33      exit 2;
  34 fi
  35
  36
  37
  38
  39 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt11t13.sql > /dev/null 2>&1
  40 exit 0;
  41