4 # Create table t1 with 5 records in csql database.
5 # Insert 10-11 records with null value in some of the records.
6 # Test group by all aggregate functions on the fields having null values
7 # Author : Jitendra Lenka
9 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
13 REL_PATH
=`pwd`/sql
/Aggregate
16 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s $REL_PATH/nulltest2.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-o 4 -s $REL_PATH/aggregate_groupby1.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
29 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql