test/sql/Predicate/test005.ksh

   1 #!/bin/ksh
   2 # Testing Relational Operators(,<,>,<,>=,!=) with varchar in Update statement. ( )
   3 # REATE TABLE t1 (f1 INT , f2 VARCHAR (12));
   4 # NSERT INTO t1 VALUES(1, 'ABCDE');
   5 # NSERT INTO t1 VALUES(2, 'ABCDF');
   6 # NSERT INTO t1 VALUES(3, 'ABCDG');
   7 # NSERT INTO t1 VALUES(4, 'ABCDH');
   8 # NSERT INTO t1 VALUES(5, 'ABCDI');
   9 # NSERT INTO t1 VALUES(6, 'NBCDE');
  10 # NSERT INTO t1 VALUES(7, 'NBCDF');
  11 # NSERT INTO t1 VALUES(8, 'NBCDG');
  12 # NSERT INTO t1 VALUES(9, 'NBCDH');
  13 # NSERT INTO t1 VALUES(10, 'NBCDI');
  14 # est the below Update statements return proper result set or not.
  15 # elect * from t1;
  16 # pdate t1 set f1=100, f2='Lakshya10' where f2='NBCDI';
  17 # pdate t1 set f1=85, f2='Lakshya8.5' where f2>='NBCDG';
  18 # pdate t1 set f1=70, f2='Lakshya7' where f2>'NBCDE';
  19 # pdate t1 set f1=15, f2='Lakshya1.5' where f2<'ABCDG';
  20 # update t1 set f1=30, f2='Lakshya3' where f2<='ABCDH';
  21 # update t1 set f1=55, f2='Lakshya5.5' where f2!='Lakshya8.5';
  22 #
  23 CREATEFILE=${PWD}/sql/Predicate/csql.conf
  24 REL_PATH=.
  25 if [ -s "$CREATEFILE" ]
  26 then
  27     REL_PATH=`pwd`/sql/Predicate
  28 fi
  29
  30 echo "drop table t1;" >${REL_PATH}/dropt1.sql
  31
  32 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql >/dev/null 2>&1
  33
  34 if [ "$VALGRIND" = "true" ]
  35 then
  36     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar_relational_upd.sql
  37 else
  38     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/varchar_relational_upd.sql
  39     if [ $? -ne 0 ]
  40     then
  41        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  42        rm -f ${REL_PATH}/dropt1.sql
  43        exit 1;
  44     fi
  45 fi
  46
  47 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropt1.sql
  48 if [ $? -ne 0 ]
  49 then
  50    exit 2;
  51 fi
  52
  53 rm -f ${REL_PATH}/dropt1.sql
  54 exit 0;