test/tools/csql/testnw026.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # check binary data type table t1 field f1 int ,f2 binary(4)
   4 #
   5 QUITFILE=${PWD}/tools/csql/quit.sql
   6 REL_PATH=.
   7 if [ -s "$QUITFILE" ]
   8 then
   9     REL_PATH=`pwd`/tools/csql
  10 fi
  11 echo "drop table t1;" > ${REL_PATH}/dropp_t1.sql
  12
  13 $CSQL_INSTALL_ROOT/bin/csql -o 4 -s ${REL_PATH}/datatype10.sql
  14 if [ $? -ne 0 ]
  15 then
  16    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  17    rm -f ${REL_PATH}/dropp_t1.sql
  18    exit 1;
  19 fi
  20 $CSQL_INSTALL_ROOT/bin/csql -o 4 -s ${REL_PATH}/datatype11.sql
  21 if [ $? -ne 0 ]
  22 then
  23    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  24    rm -f ${REL_PATH}/dropp_t1.sql
  25    exit 2;
  26 fi
  27 $CSQL_INSTALL_ROOT/bin/csql -o 4 -s ${REL_PATH}/datatype12.sql
  28 if [ $? -ne 0 ]
  29 then
  30    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  31    rm -f ${REL_PATH}/dropp_t1.sql
  32    exit 3;
  33 fi
  34 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  35 if [ $? -ne 0 ]
  36 then
  37    rm -f ${REL_PATH}/dropp_t1.sql
  38    exit 4;
  39 fi
  40 rm -f ${REL_PATH}/dropp_t1.sql
  41 exit 0;