test/sql/Join/test010.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # Create t11 table with 5 fields(f1,f2,f3,f4,f5)
   4 # Create t12 with 3 fields(f1,f2,f3)
   5 # Create t13 with 2 fields(f7,f8)
   6 # Insert 3 records in each.
   7 # (a)select * from t11,t12,t13 where t12.f1=t13.f8 and t13.f7=t11.f1;
   8 # (b)select * from t11,t12,t13 where t12.f1=t13.f8 or t13.f7=t11.f1;
   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 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/tablet11t12t13.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/join10.sql
  26 if [ $? -ne 0 ]
  27   then
  28      $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt11t12t13.sql > /dev/null 2>&1
  29      exit 2;
  30 fi
  31
  32 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt11t12t13.sql > /dev/null 2>&1
  33 exit 0;
  34