test/sql/Aggregate/test028.ksh

   1 #!/bin/ksh
   2 # Testing Join on 5 sales tables.
   3 # Create table with all datatypes except float and double.
   4 # Insert 20 records with null value in some fields.
   5 # Select records using Group by.
   6 # Select records using Group by and having.
   7 # Select records using Group by on multiple fields in different combination.
   8 # Select records using Group by on multiple fields and having on sum().
   9 # Test group by on NULL fields.
  10 #
  11 QUITFILE=${PWD}/sql/Aggregate/quit.sql
  12 REL_PATH=.
  13 if [ -s "$QUITFILE" ]
  14 then
  15     REL_PATH=`pwd`/sql/Aggregate
  16 fi
  17
  18 if [ "$VALGRIND" = "true" ]
  19 then
  20     valgrind --tool=memcheck --leak-check=full  $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/alldatatype.sql 2> $0.valgr
  21 else
  22     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/alldatatype.sql
  23     if [ $? -ne 0 ]
  24     then
  25        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  26        exit 1;
  27     fi
  28 fi
  29
  30 if [ "$VALGRIND" = "true" ]
  31 then
  32     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/alldatatype_aggregate_sum.sql 2>> $0.valgr
  33 else
  34     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/alldatatype_aggregate_sum.sql
  35     if [ $? -ne 0 ]
  36     then
  37        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  38        exit 2;
  39     fi
  40 fi
  41
  42 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  43 if [ $? -ne 0 ]
  44 then
  45    exit 3;
  46 fi
  47
  48 exit 0;