test/sql/Aggregate/testnw034.ksh

   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
   6 #
   7 QUITFILE=${PWD}/sql/Aggregate/quit.sql
   8 REL_PATH=.
   9 if [ -s "$QUITFILE" ]
  10 then
  11     REL_PATH=`pwd`/sql/Aggregate
  12 fi
  13
  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;
  19 fi
  20
  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;
  26 fi
  27
  28 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  29 if [ $? -ne 0 ]
  30 then
  31    exit 3;
  32 fi
  33
  34 exit 0;