test/sql/Optimizer/test024.ksh

   1 #!/bin/ksh
   2 # Self Join test using explain plan(Hash index on both table).
   3 # create table t1(f1 int, f2 int);
   4 # create index hashidxt1f1 on t1(f1) hash;
   5 # create index hashidxt1f2 on t1(f2) hash;
   6 # explain plan select * from t1,t2;
   7 # explain plan select a.f1,b.f1 from t1 a, t1 b where a.f1=b.f1;
   8 #
   9 QUITFILE=${PWD}/sql/Optimizer/drop.sql
  10 REL_PATH=.
  11 if [ -s "$QUITFILE" ]
  12 then
  13 REL_PATH=`pwd`/sql/Optimizer
  14 fi
  15
  16 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  17
  18 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  19
  20 if [ "$VALGRIND" = "true" ]
  21 then
  22     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/selfjoin_hash_int.sql
  23 else
  24     $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/selfjoin_hash_int.sql
  25     if [ $? -ne 0 ]
  26     then
  27       rm -f ${REL_PATH}/dropt1.sql
  28       exit 1;
  29     fi
  30 fi
  31
  32 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1.sql
  33 rm -f ${REL_PATH}/dropt1.sql
  34
  35 exit 0;
  36