test/sql/Join/test085.ksh

   1 #!/bin/ksh
   2 # Testing Left Join on three tables with All Datatypes.
   3 # select t1.f1, t1.f2, t2.f1, t2.f2, t3.f1, t3.f2 from t1 inner join t2 on t1.f1 = t2.f1 inner join t3 on t2.f1 = t3.f1 inner join t1 on t3.f1 = t1.f1;
   4 #
   5 CREATEFILE=${PWD}/sql/Join/dropt1t2.sql
   6 REL_PATH=.
   7 if [ -s "$CREATEFILE" ]
   8 then
   9     REL_PATH=`pwd`/sql/Join
  10 fi
  11
  12 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/alldatatype.sql
  13 if [ $? -ne 0 ]
  14 then
  15    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop_t1_t2_t3.sql
  16    exit 1;
  17 fi
  18
  19 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/inner_t1_t2_t3_t1.sql
  20 if [ $? -ne 0 ]
  21 then
  22    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop_t1_t2_t3.sql
  23    exit 2;
  24 fi
  25
  26 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop_t1_t2_t3.sql
  27 if [ $? -ne 0 ]
  28 then
  29    exit 3;
  30 fi
  31
  32 exit 0;