test/sql/Datatype/test003.ksh

   1 #!/bin/ksh
   2 # Autoincreament should not work on Varchar.
   3 # Create table t1( f1 int, f2 varchar(15) AUTO_INCREMENT);
   4 # This statement execution should be failed.
   5 #
   6 CREATEFILE=${PWD}/sql/Datatype/csql.conf
   7 REL_PATH=.
   8 if [ -s "$CREATEFILE" ]
   9 then
  10     REL_PATH=`pwd`/sql/Datatype
  11 fi
  12
  13 echo "echo Create table t1( f1 int, f2 varchar(15) AUTO_INCREMENT);" >${REL_PATH}/varchar_autoincrement.sql
  14 echo "Create table t1( f1 int, f2 varchar(15) AUTO_INCREMENT);" >>${REL_PATH}/varchar_autoincrement.sql
  15 echo "echo show tables;" >>${REL_PATH}/varchar_autoincrement.sql
  16 echo "show tables;" >>${REL_PATH}/varchar_autoincrement.sql
  17
  18 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  19
  20 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  21
  22 if [ "$VALGRIND" = "true" ]
  23 then
  24     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar_autoincrement.sql
  25 else
  26     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar_autoincrement.sql
  27     if [ $? -ne 0 ]
  28     then
  29        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  30        rm -f ${REL_PATH}/varchar_autoincrement.sql ${REL_PATH}/dropt1.sql
  31        exit 1;
  32     fi
  33 fi
  34
  35 if [ "$VALGRIND" = "true" ]
  36 then
  37     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  38 else
  39     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  40 fi
  41
  42 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  43 if [ $? -ne 0 ]
  44 then
  45    exit 2;
  46 fi
  47
  48 rm -f ${REL_PATH}/varchar_autoincrement.sql ${REL_PATH}/dropt1.sql
  49 exit 0;