test/sql/Optimizer/test001.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # No Primary key tests
   4 # 1)Single table no predicate should use table scan
   5 # 2)Single table equi predicate on f1 should use table scan
   6 # 3)Single table range predicate on f1 should use table scan
   7 # Primary key tests: create primary hash index on f1
   8 # 4)Single table no predicate should use table scan
   9 # 5)Single table equi predicate on f1 should use hash scan
  10 # 6)Single table range predicate on f1 should use table scan
  11 # Hash Index tests:create hash index on f2
  12 # 7)Single table no predicate should use table scan
  13 # 8)Single table equi predicate on f2 should use hash scan
  14 # 9)Single table range predicate on f2 should use table scan
  15 # Tree Index tests:create tree index on f2
  16 # 10)Single table no predicate should use table scan
  17 # 11)Single table equi predicate on f2 should use tree scan
  18 # 12)Single table range predicate on f2 should use tree scan
  19 QUITFILE=${PWD}/sql/Optimizer/drop.sql
  20 REL_PATH=.
  21 if [ -s "$QUITFILE" ]
  22 then
  23 REL_PATH=`pwd`/sql/Optimizer
  24 fi
  25
  26 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/createt1t2t3.sql > /dev/null 2>&1
  27 if [ $? -ne 0 ]
  28 then
  29   exit 1;
  30 fi
  31 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/singletabletest1.sql
  32 if [ $? -ne 0 ]
  33 then
  34   $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
  35   exit 2;
  36 fi
  37
  38 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop.sql > /dev/null 2>&1
  39  exit 0;
  40