2 # Testing limit and offset on self joined table.
4 CREATEFILE
=${PWD}/sql
/Limit
/dropt1.sql
6 if [ -s "$CREATEFILE" ]
8 REL_PATH
=`pwd`/sql
/Limit
12 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/selfjoin1.sql
15 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropemp10.sql
19 echo "drop table emp10;" >${REL_PATH}/dropemp10.sql
20 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropemp10.sql
23 rm -f ${REL_PATH}/dropemp10.sql
26 rm -f ${REL_PATH}/dropemp10.sql