test/sql/Order/test005.ksh

   1 #!/bin/ksh
   2 # Testing Field Format for both Projection list and order by list.
   3 # Order by <single field> and <multiple fields> in ascending order on single table with where clause
   4 # Order by <single field> and <multiple fields> in descending order on single table with where clause
   5 #
   6 CREATEFILE=${PWD}/sql/Order/drop_Articles_Authors_AuthorArticle.sql
   7 REL_PATH=.
   8 if [ -s "$CREATEFILE" ]
   9 then
  10     REL_PATH=`pwd`/sql/Order
  11 fi
  12
  13 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/table_t1.sql
  14 if [ $? -ne 0 ]
  15 then
  16    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  17    exit 1;
  18 fi
  19
  20 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/order_single_multiple.sql
  21 if [ $? -ne 0 ]
  22 then
  23    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  24    exit 2;
  25 fi
  26
  27 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  28 if [ $? -ne 0 ]
  29 then
  30    exit 3;
  31 fi
  32
  33 exit 0;