code reorg
[csql.git] / test / sql / Aggregate / test009.ksh
blob297c78c3a30bc3769b13b0e10ea2bd24c18caf7b
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
8 # Author : Jitendra Lenka
10 QUITFILE=${PWD}/sql/Aggregate/quit.sql
11 REL_PATH=.
12 if [ -s "$QUITFILE" ]
13 then
14 REL_PATH=`pwd`/sql/Aggregate
17 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/createt1.sql > /dev/null 2>&1
18 if [ $? -ne 0 ]
19 then
20 exit 1;
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;
34 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1.sql > /dev/null 2>&1
35 exit 0;