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.
9 # Author : Jitendra Lenka
11 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
15 REL_PATH
=`pwd`/sql
/Aggregate
18 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2.sql
> /dev
/null
2>&1
24 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s $REL_PATH/aggregate4.sql
27 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
30 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1