3 # create hash index on f1 and tree index on f2 and no index on f3
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
18 REL_PATH
=`pwd`/sql
/Optimizer
21 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2t3.sql
> /dev
/null
2>&1
26 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/singletabletest2.sql
29 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1
33 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1