test/sql/Limit/test004.ksh

   1 #!/bin/ksh
   2 # Testing limit and offset on GROUP BY and HAVING.
   3 #
   4 CREATEFILE=${PWD}/sql/Limit/dropt1.sql
   5 REL_PATH=.
   6 if [ -s "$CREATEFILE" ]
   7 then
   8     REL_PATH=`pwd`/sql/Limit
   9 fi
  10
  11 if [ "$VALGRIND" = "true" ]
  12 then
  13     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/groupby.sql 2> $0.valgr
  14 else
  15     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/groupby.sql
  16     if [ $? -ne 0 ]
  17     then
  18        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  19        exit 1;
  20     fi
  21 fi
  22
  23 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  24 if [ $? -ne 0 ]
  25 then
  26    exit 2;
  27 fi
  28
  29 exit 0;