test/tools/csql/test102.ksh

   1 #!/bin/sh
   2 # Test Case
   3 # create table T1 with 10 records, T2 with 1k records, T3 with 1k records,T4 with 1k records,T5 with 1k records.
   4 # Script to check All the aggregate functions applying equi join on these 5 tables..
   5 # The join should fetch 1000 records
   6 QUITFILE=${PWD}/tools/csql/quit.sql
   7 REL_PATH=.
   8 if [ -s "$QUITFILE" ]
   9 then
  10     REL_PATH=`pwd`/tools/csql
  11 fi
  12
  13 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/createjoin.sql
  14 if [ $? -ne 0 ]
  15 then
  16    exit 1;
  17 fi
  18
  19 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert10000T1.sql >/dev/null 2>&1
  20 if [ $? -ne 0 ]
  21 then
  22    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop5.sql
  23    exit 2;
  24 fi
  25
  26 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert1000T2.sql >/dev/null 2>&1
  27 if [ $? -ne 0 ]
  28 then
  29    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop5.sql
  30    exit 3;
  31 fi
  32
  33 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert1000T3.sql >/dev/null 2>&1
  34 if [ $? -ne 0 ]
  35 then
  36    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop5.sql
  37    exit 4;
  38 fi
  39
  40 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert1000T4.sql >/dev/null 2>&1
  41 if [ $? -ne 0 ]
  42 then
  43    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop5.sql
  44    exit 5;
  45 fi
  46
  47 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert1000T5.sql >/dev/null 2>&1
  48 if [ $? -ne 0 ]
  49 then
  50    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop5.sql
  51    exit 6;
  52 fi
  53
  54 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/aggregate_join_10k_1k_1k_1k_1k.sql
  55 if [ $? -ne 0 ]
  56 then
  57    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop5.sql
  58    exit 7;
  59 fi
  60
  61 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop5.sql
  62 if [ $? -ne 0 ]
  63 then
  64    exit 8;
  65 fi
  66
  67 exit 0;