test/sql/Join/test037.ksh

   1 #!/bin/ksh
   2 #
   3 QUITFILE=${PWD}/sql/Join/quit.sql
   4 REL_PATH=.
   5 if [ -s "$QUITFILE" ]
   6 then
   7  REL_PATH=`pwd`/sql/Join
   8 fi
   9
  10 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/noindex_t1_t2_t3.sql
  11 if [ $? -ne 0 ]
  12 then
  13   exit 1;
  14 fi
  15 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/hashon_t1f1_t2f1_t3f1.sql
  16 if [ $? -ne 0 ]
  17 then
  18   exit 2;
  19 fi
  20 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/insert_t1_t2_t3.sql
  21 if [ $? -ne 0 ]
  22 then
  23   exit 3;
  24 fi
  25 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/equijoin2_with_and_t1_t2_t3.sql
  26 if [ $? -ne 0 ]
  27 then
  28   exit 4;
  29 fi
  30 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop_t1_t2_t3.sql
  31 if [ $? -ne 0 ]
  32 then
  33   exit 5;
  34 fi