*** empty log message ***
[csql.git] / test / sql / Order / test008.ksh
blob5ff805c6e0d3f77f6e717fd7a85466cd1bcbb7e7
1 #!/bin/ksh
2 # Testing Order by applying INNER JOIN on multiple tables.
4 CREATEFILE=${PWD}/sql/Order/dropt1.sql
5 REL_PATH=.
6 if [ -s "$CREATEFILE" ]
7 then
8 REL_PATH=`pwd`/sql/Order
9 fi
11 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/table_t1_t2_t3.sql
12 if [ $? -ne 0 ]
13 then
14 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop_t1_t2_t3.sql
15 exit 1;
18 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/order_inner.sql
19 if [ $? -ne 0 ]
20 then
21 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop_t1_t2_t3.sql
22 exit 2;
25 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drop_t1_t2_t3.sql
26 if [ $? -ne 0 ]
27 then
28 exit 3;
31 exit 0;