test/tools/csql/test100.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # Testing all DML on large size allocate
   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
  12 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/largetable1.sql
  13 if [ $? -ne 0 ]
  14 then
  15    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drt1.sql
  16    exit 1;
  17 fi
  18
  19 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  20 if [ $? -ne 0 ]
  21 then
  22    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  23    exit 2;
  24 fi
  25
  26 echo "update t1 set f2='LAKSHYA-CSQL' where f1>=3;"
  27 echo "update t1 set f2='LAKSHYA-CSQL' where f1>=3;" >${REL_PATH}/largetableupdate1.sql
  28 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/largetableupdate1.sql
  29 if [ $? -ne 0 ]
  30 then
  31    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  32    rm -f ${REL_PATH}/largetableupdate1.sql
  33    exit 3;
  34 fi
  35
  36 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/selectstar.sql
  37 if [ $? -ne 0 ]
  38 then
  39    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  40    rm -f ${REL_PATH}/largetableupdate1.sql
  41    exit 4;
  42 fi
  43
  44 echo "delete from t1 where f1<= 7;"
  45 echo "delete from t1 where f1<= 7;" >${REL_PATH}/largetabledelete1.sql
  46 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/largetabledelete1.sql
  47 if [ $? -ne 0 ]
  48 then
  49    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  50    rm -f ${REL_PATH}/largetableupdate1.sql ${REL_PATH}/largetabledelete1.sql
  51    exit 5;
  52 fi
  53
  54 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/selectstar.sql
  55 if [ $? -ne 0 ]
  56 then
  57    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  58    rm -f ${REL_PATH}/largetableupdate1.sql ${REL_PATH}/largetabledelete1.sql
  59    exit 6;
  60 fi
  61
  62 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  63 if [ $? -ne 0 ]
  64 then
  65    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  66    rm -f ${REL_PATH}/largetableupdate1.sql ${REL_PATH}/largetabledelete1.sql
  67    exit 7;
  68 fi
  69
  70 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
  71 if [ $? -ne 0 ]
  72 then
  73    rm -f ${REL_PATH}/largetableupdate1.sql ${REL_PATH}/largetabledelete1.sql
  74    exit 8;
  75 fi
  76 rm -f ${REL_PATH}/largetableupdate1.sql ${REL_PATH}/largetabledelete1.sql
  77 exit 0;