test/sql/Alter/test002.ksh

   1 #!/bin/ksh
   2 # Renaming table name to an existing table name.
   3 # Create table t3(f1 int, f2 char(10));
   4 # Create table t1(f1 int, f2 char(10));
   5 # rename table t1 to t3. It sghould be Failed
   6 #
   7 CREATEFILE=${PWD}/sql/Alter/csql.conf
   8 REL_PATH=.
   9 if [ -s "$CREATEFILE" ]
  10 then
  11     REL_PATH=`pwd`/sql/Alter
  12 fi
  13
  14 echo "create table t3(f1 int,f2 char(20));" >${REL_PATH}/createtable.sql
  15 echo "create table t1(f1 int,f2 char(20));" >>${REL_PATH}/createtable.sql
  16 echo "rename table t1 to t3;" >${REL_PATH}/renametable.sql
  17 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  18 echo "drop table t3;" >${REL_PATH}/dropt3.sql
  19
  20 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  21 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt3.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}/renametable.sql
  32        rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/dropt3.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}/renametable.sql
  42 else
  43     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/renametable.sql
  44     if [ $? -ne 0 ]
  45     then
  46        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt3.sql
  47        rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/renametable.sql
  48        rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/dropt3.sql
  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 if [ $? -eq 0 ]
  57     then
  58         echo Test Passed.
  59     else
  60         echo Test Failed.
  61 fi
  62
  63 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  64 if [ $? -ne 0 ]
  65 then
  66    exit 3;
  67 fi
  68
  69 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt3.sql >/dev/null 2>&1
  70 if [ $? -ne 0 ]
  71 then
  72    exit 4;
  73 fi
  74
  75 rm -f ${REL_PATH}/createtable.sql ${REL_PATH}/renametable.sql
  76 rm -f ${REL_PATH}/dropt1.sql ${REL_PATH}/dropt3.sql
  77 rm -f ${REL_PATH}/beforealter ${REL_PATH}/afteralter
  78
  79 exit 0;