code reorg
[csql.git] / test / sql / Aggregate / testnw034.ksh
blobb4056e9aaa5569b47e8a052615c212f9bc326cd0
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 # This test for test max() on char,date,time,timestamp in different combination
7 QUITFILE=${PWD}/sql/Aggregate/quit.sql
8 REL_PATH=.
9 if [ -s "$QUITFILE" ]
10 then
11 REL_PATH=`pwd`/sql/Aggregate
14 $CSQL_INSTALL_ROOT/bin/csql -o 4 -s ${REL_PATH}/alldatatype.sql
15 if [ $? -ne 0 ]
16 then
17 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
18 exit 1;
21 $CSQL_INSTALL_ROOT/bin/csql -o 4 -s ${REL_PATH}/char_datetypes_max.sql
22 if [ $? -ne 0 ]
23 then
24 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
25 exit 2;
28 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
29 if [ $? -ne 0 ]
30 then
31 exit 3;
34 exit 0;