test/sql/Aggregate/test009.ksh

   1 #!/bin/ksh
   2 #Test Case
   3 # Create table t1 with 5 records in csql database.
   4 # select query with expression in aggregate
   5 # as we do not support expressions in aggregate, it should give syntax error
   6
   7
   8 #       Author : Jitendra Lenka
   9
  10 QUITFILE=${PWD}/sql/Aggregate/quit.sql
  11 REL_PATH=.
  12 if [ -s "$QUITFILE" ]
  13 then
  14   REL_PATH=`pwd`/sql/Aggregate
  15 fi
  16
  17 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/createt1.sql > /dev/null 2>&1
  18 if [ $? -ne 0 ]
  19  then
  20    exit 1;
  21 fi
  22
  23
  24 echo "select sum(12*f1) where f4='BBB':"
  25 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/aggsum3.sql
  26 if [ $? -ne 0 ]
  27   then
  28     $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1.sql > /dev/null 2>&1
  29     exit 2;
  30  fi
  31
  32
  33
  34 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1.sql > /dev/null 2>&1
  35 exit 0;
  36