core reorg
[csql.git] / test / sql / Aggregate / testnw004.ksh
blob098aad41517ff2fcc21e7e770c5ae91fe92fd7d9
1 #!/bin/ksh
2 #Test Case
3 # create table t1(f1 int,f2 int,f3 int,primary key(f1));
4 # create table t2(f1 int,f2 int,f3 int,primary key(f1));
5 # Insert 5 records in each.
6 # Test all aggregate functions applying conditions
7 # Test all aggregate functions applying conditions and group by.
8 #
9 # Author : Jitendra Lenka
11 QUITFILE=${PWD}/sql/Aggregate/quit.sql
12 REL_PATH=.
13 if [ -s "$QUITFILE" ]
14 then
15 REL_PATH=`pwd`/sql/Aggregate
18 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/createt1t2.sql > /dev/null 2>&1
19 if [ $? -ne 0 ]
20 then
21 exit 1;
24 $CSQL_INSTALL_ROOT/bin/csql -o 4 -s $REL_PATH/aggregate4.sql
25 if [ $? -ne 0 ]
26 then
27 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2.sql > /dev/null 2>&1
28 exit 2;
29 fi
30 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt1t2.sql > /dev/null 2>&1
31 exit 0;