test/sql/Join/test009.ksh

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