test/sql/Alter/test009.ksh

   1 #!/bin/ksh
   2 # Dropping an existing column from a Table.
   3 # Create table t1(f1 int,f2 char(10),f3 float);
   4 # Alter table t1 drop column f3;
   5 #
   6 CREATEFILE=${PWD}/sql/Alter/csql.conf
   7 REL_PATH=.
   8 if [ -s "$CREATEFILE" ]
   9 then
  10     REL_PATH=`pwd`/sql/Alter
  11 fi
  12
  13 echo "create table t1(f1 int,f2 char(20), f3 float);" >${REL_PATH}/createtable.sql
  14 echo "insert into t1 values(1,'CSQL_LAKSHYA',50.5);" >>${REL_PATH}/createtable.sql
  15 echo "echo alter table t1 drop column f3;" >${REL_PATH}/dropcolumn.sql
  16 echo "alter table t1 drop column f3;" >>${REL_PATH}/dropcolumn.sql
  17 echo "echo select * from t1;" >>${REL_PATH}/dropcolumn.sql
  18 echo "select * from t1;" >>${REL_PATH}/dropcolumn.sql
  19 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  20
  21 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  22
  23 if [ "$VALGRIND" = "true" ]
  24 then
  25     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/createtable.sql
  26 else
  27     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/createtable.sql
  28     if [ $? -ne 0 ]
  29     then
  30        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  31        rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/dropcolumn.sql
  32        rm -f ${REL_PATH}/dropt1.sql
  33        exit 1;
  34     fi
  35 fi
  36
  37 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l >${REL_PATH}/beforealter
  38
  39 if [ "$VALGRIND" = "true" ]
  40 then
  41     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropcolumn.sql
  42 else
  43     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropcolumn.sql
  44     if [ $? -ne 0 ]
  45     then
  46        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  47        rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/dropcolumn.sql
  48        rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/beforealter
  49        exit 2;
  50     fi
  51 fi
  52
  53 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l >${REL_PATH}/afteralter
  54
  55 diff ${REL_PATH}/beforealter ${REL_PATH}/afteralter
  56
  57 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  58 if [ $? -ne 0 ]
  59 then
  60    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  61    rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/dropcolumn.sql
  62    rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/beforealter ${REL_PATH}/afteralter
  63    exit 3;
  64 fi
  65
  66 rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/dropcolumn.sql
  67 rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/beforealter ${REL_PATH}/afteralter
  68
  69 exit 0;