test/sql/Optimizer/test002.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # create hash index on f1 and tree index on f2 and no index on f3
   4 # Multiple Predicates
   5 # 1)Single table equi predicate with f1 and f3 should use hash scan
   6 # 2)Single table range predicate on f1  and equi on f3 should use tree scan
   7 # 3)Single table equi on f3 and range predicate on f1 should use tree scan
   8 # Disjunctive predicates
   9 # 4)Single table nonequi predicate on f1 should use full scan
  10 # 5)Single table nonequi predicate on f2 should use full scan
  11 # 6)Single table f1=10 or f3=20 should use full scan
  12 # 7)Single table f2>10 or f3=20 should use full scan
  13 # 8)Single table f3=20 or f2 >10 should use full scan
  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 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/createt1t2t3.sql > /dev/null 2>&1
  22 if [ $? -ne 0 ]
  23 then
  24   exit 1;
  25 fi
  26 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/singletabletest2.sql
  27 if [ $? -ne 0 ]
  28 then
  29   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
  30   exit 2;
  31 fi
  32
  33 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
  34  exit 0;
  35