test/sql/Datatype/test010.ksh

   1 #!/bin/ksh
   2 # Testing VARCHAR Datatype without index
   3 # All DML testing
   4 #
   5 CREATEFILE=${PWD}/sql/Datatype/csql.conf
   6 REL_PATH=.
   7 if [ -s "$CREATEFILE" ]
   8 then
   9     REL_PATH=`pwd`/sql/Datatype
  10 fi
  11
  12 echo "echo create table t1(f1 varchar(20),f2 varchar(30));" >${REL_PATH}/varchar.sql
  13 echo "create table t1(f1 varchar(20),f2 varchar(30));" >>${REL_PATH}/varchar.sql
  14 echo "insert into t1 values('CSQL1','Lakshya1');" >>${REL_PATH}/varchar.sql
  15 echo "insert into t1 values('CSQL2','Lakshya2');" >>${REL_PATH}/varchar.sql
  16 echo "insert into t1 values('CSQL3','Lakshya3');" >>${REL_PATH}/varchar.sql
  17 echo "insert into t1 values('CSQL4','Lakshya4');" >>${REL_PATH}/varchar.sql
  18 echo "insert into t1 values('CSQL5','Lakshya5');" >>${REL_PATH}/varchar.sql
  19 echo "echo select * from t1;" >>${REL_PATH}/varchar.sql
  20 echo "select * from t1;" >>${REL_PATH}/varchar.sql
  21 echo "echo select * from t1 where f1='CSQL4' or f1='CSQL2';" >>${REL_PATH}/varchar.sql
  22 echo "select * from t1 where f1='CSQL4' or f1='CSQL2';" >>${REL_PATH}/varchar.sql
  23 echo "echo update t1 set f2='LAKSHYA' where f1='CSQL2' or f1='CSQL4';" >>${REL_PATH}/varchar.sql
  24 echo "update t1 set f2='LAKSHYA' where f1='CSQL2' or f1='CSQL4';" >>${REL_PATH}/varchar.sql
  25 echo "echo select * from t1;" >>${REL_PATH}/varchar.sql
  26 echo "select * from t1;" >>${REL_PATH}/varchar.sql
  27 echo "echo delete from t1 where f1 in ('CSQL1','CSQL3','CSQL5');" >>${REL_PATH}/varchar.sql
  28 echo "delete from t1 where f1 in ('CSQL1','CSQL3','CSQL5');" >>${REL_PATH}/varchar.sql
  29 echo "echo select * from t1;" >>${REL_PATH}/varchar.sql
  30 echo "select * from t1;" >>${REL_PATH}/varchar.sql
  31
  32 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  33
  34 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  35
  36 if [ "$VALGRIND" = "true" ]
  37 then
  38     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar.sql
  39 else
  40     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar.sql
  41     if [ $? -ne 0 ]
  42     then
  43        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  44        rm -f ${REL_PATH}/varchar.sql ${REL_PATH}/dropt1.sql
  45        exit 1;
  46     fi
  47 fi
  48
  49 if [ "$VALGRIND" = "true" ]
  50 then
  51     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  52 else
  53     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -l
  54 fi
  55
  56 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  57 if [ $? -ne 0 ]
  58 then
  59    exit 2;
  60 fi
  61 rm -f ${REL_PATH}/varchar.sql ${REL_PATH}/dropt1.sql
  62 exit 0;