test/sql/Join/test008.ksh

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