test/tools/csql/test128.ksh

   1 #!/bin/sh
   2 # The same is present in testnw028.ksh (wih network)
   3 # Default and 'now' testing for Date, Time and Timestamp datatypes
   4 #
   5
   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 if [ "$VALGRIND" = "true" ]
  14 then
  15     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/csqlnow.sql 2> $0.valgr
  16 else
  17 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/csqlnow.sql
  18 if [ $? -ne 0 ]
  19 then
  20    exit 1;
  21 fi
  22 fi
  23
  24
  25 sleep 1
  26 echo "echo INSERT INTO t1(f2) VALUES('NOW');" >${REL_PATH}/insnow.sql
  27 echo "INSERT INTO t1(f2) VALUES('NOW');" >>${REL_PATH}/insnow.sql
  28 if [ "$VALGRIND" = "true" ]
  29 then
  30     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insnow.sql 2>> $0.valgr
  31 else
  32     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insnow.sql
  33     if [ $? -ne 0 ]
  34     then
  35        rm -f ${REL_PATH}/insnow.sql
  36        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  37        exit 2;
  38     fi
  39 fi
  40
  41 sleep 1
  42 echo "echo INSERT INTO t1(f3) VALUES('NOW');" >${REL_PATH}/insnow.sql
  43 echo "INSERT INTO t1(f3) VALUES('NOW');" >>${REL_PATH}/insnow.sql
  44 if [ "$VALGRIND" = "true" ]
  45 then
  46     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insnow.sql 2>> $0.valgr
  47 else
  48     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insnow.sql
  49     if [ $? -ne 0 ]
  50     then
  51        rm -f ${REL_PATH}/insnow.sql
  52        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  53        exit 3;
  54     fi
  55 fi
  56
  57 sleep 1
  58 echo "echo INSERT INTO t1(f4) VALUES('NOW');" >${REL_PATH}/insnow.sql
  59 echo "INSERT INTO t1(f4) VALUES('NOW');" >>${REL_PATH}/insnow.sql
  60 if [ "$VALGRIND" = "true" ]
  61 then
  62     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insnow.sql 2>> $0.valgr
  63 else
  64     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insnow.sql
  65     if [ $? -ne 0 ]
  66     then
  67        rm -f ${REL_PATH}/insnow.sql
  68        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  69        exit 4;
  70     fi
  71 fi
  72
  73 echo "echo SELECT * FROM t1;" >${REL_PATH}/selnow.sql
  74 echo "SELECT * FROM t1;" >>${REL_PATH}/selnow.sql
  75 if [ "$VALGRIND" = "true" ]
  76 then
  77     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/selnow.sql 2>> $0.valgr
  78 else
  79     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/selnow.sql
  80     if [ $? -ne 0 ]
  81     then
  82        rm -f ${REL_PATH}/insnow.sql
  83        rm -f ${REL_PATH}/selnow.sql
  84        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  85        exit 5;
  86     fi
  87 fi
  88
  89 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  90 if [ $? -ne 0 ]
  91 then
  92    rm -f ${REL_PATH}/insnow.sql
  93    exit 6;
  94 fi
  95
  96 rm -f ${REL_PATH}/insnow.sql
  97 rm -f ${REL_PATH}/selnow.sql
  98 exit 0;