test/sql/Optimizer/test021.ksh

   1 #!/bin/ksh
   2 # Left OuterJoin test using explain plan(Tree index on both table).
   3 # create table t1(f1 int, f2 int);
   4 # create index treeidxt1f1 on t1(f1) tree;
   5 # create index treeidxt1f2 on t1(f2) tree;
   6 # create table t2(f1 int, f2 int);
   7 # create index treeidxt2f1 on t2(f1) tree;
   8 # create index treeidxt2f2 on t2(f2) tree;
   9 # explain plan select * from t1,t2;
  10 # explain plan select * from t1 left join t2 on t1.f1=t2.f1;
  11 # explain plan select * from t1 left join t2 on t1.f1<=t2.f1;
  12 # explain plan select * from t1 left join t2 on t1.f1!=t2.f1;
  13 #
  14 QUITFILE=${PWD}/sql/Optimizer/drop.sql
  15 REL_PATH=.
  16 if [ -s "$QUITFILE" ]
  17 then
  18 REL_PATH=`pwd`/sql/Optimizer
  19 fi
  20
  21 echo "drop table t1;" >${REL_PATH}/dropt1t2.sql
  22 echo "drop table t2;" >>${REL_PATH}/dropt1t2.sql
  23
  24 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1t2.sql >/dev/null 2>&1
  25
  26 if [ "$VALGRIND" = "true" ]
  27 then
  28     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/leftjoin_tree_int.sql
  29 else
  30     $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/leftjoin_tree_int.sql
  31     if [ $? -ne 0 ]
  32     then
  33       rm -f ${REL_PATH}/dropt1t2.sql
  34       exit 1;
  35     fi
  36 fi
  37
  38 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2.sql
  39 rm -f ${REL_PATH}/dropt1t2.sql
  40
  41 exit 0;
  42