code reorg
[csql.git] / test / sql / Aggregate / testnw033.ksh
blob7d34262403c050f5bc4413b7da8523dd9361c5b2
1 #!/bin/ksh
2 # Testing Join on 5 sales tables.
3 # Create table with all datatypes except float and double.
4 # Insert 16 records.
5 # Select records using Group by.
6 # Select records using Group by and having.
7 # Test group by on NULL fields.
8 # Test Aggregate min() on char,date, time and timestamp.
9 # Select records using Group by on multiple fields and having on min(). .
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 -o 4 -s ${REL_PATH}/alldatatype.sql
19 if [ $? -ne 0 ]
20 then
21 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
22 exit 1;
25 $CSQL_INSTALL_ROOT/bin/csql -o 4 -s ${REL_PATH}/char_datetypes_min.sql
26 if [ $? -ne 0 ]
27 then
28 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
29 exit 2;
32 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
33 if [ $? -ne 0 ]
34 then
35 exit 3;
38 exit 0;