test/sql/Alter/test003.ksh

   1 #!/bin/ksh
   2 # Renaming an existing column_name to new_name.
   3 # Create table t1(f1 int,f2 char(10));
   4 # Alter table t1 rename column f2 to f3;
   5 # Use csqldump before and after altering the table.
   6 # See the schema of both situation should be consistent.
   7 #
   8 CREATEFILE=${PWD}/sql/Alter/csql.conf
   9 REL_PATH=.
  10 if [ -s "$CREATEFILE" ]
  11 then
  12     REL_PATH=`pwd`/sql/Alter
  13 fi
  14
  15 echo "create table t1(f1 int,f2 char(20));" >${REL_PATH}/createtable.sql
  16 echo "insert into t1 values(1,'CSQL_LAKSHYA');" >>${REL_PATH}/createtable.sql
  17 echo "echo alter table t1 rename column f2 to f3;" >${REL_PATH}/renamecolumn.sql
  18 echo "alter table t1 rename column f2 to f3;" >>${REL_PATH}/renamecolumn.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}/renamecolumn.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}/renamecolumn.sql
  42 else
  43     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/renamecolumn.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}/renamecolumn.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 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  57 if [ $? -ne 0 ]
  58 then
  59    $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  60    rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/renamecolumn.sql
  61    rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/beforealter ${REL_PATH}/afteralter
  62    exit 3;
  63 fi
  64 rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/renamecolumn.sql
  65 rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/beforealter ${REL_PATH}/afteralter
  66
  67 exit 0;