test/sql/Aggregate/test030.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 max().
   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 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/alldatatype.sql
  19 if [ $? -ne 0 ]
  20 then
  21    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  22    exit 1;
  23 fi
  24
  25 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/alldatatype_aggregate_max.sql
  26 if [ $? -ne 0 ]
  27 then
  28    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  29    exit 2;
  30 fi
  31
  32 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  33 if [ $? -ne 0 ]
  34 then
  35    exit 3;
  36 fi
  37
  38 exit 0;