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
23 REL_PATH
=`pwd`/sql
/Optimizer
26 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2t3.sql
> /dev
/null
2>&1
31 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/singletabletest1.sql
34 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1
38 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1