test/sql/Join/test015.ksh

   1 #!/bin/ksh
   2 #Testing LIKE operator in Join
   3 #create table emp(eno int,ename char(10),dno int);
   4 #create table dept(deptno int,dname char(10));
   5 #insert some records into both the tables.
   6 #Test the following Select statements using join and BETWEEN operator and check the retrieved data are proper or not
   7 #select * from emp,dept where emp.ename LIKE 'K%';
   8 #select * from emp,dept where dept.dname LIKE 'S%';
   9 #select * from emp,dept where emp.ename LIKE 'K%' and dept.dname LIKE 'S%';
  10 #select * from emp,dept where emp.ename LIKE 'K%' or dept.dname LIKE 'S%';
  11 #
  12 QUITFILE=${PWD}/sql/Join/quit.sql
  13 REL_PATH=.
  14 if [ -s "$QUITFILE" ]
  15 then
  16  REL_PATH=`pwd`/sql/Join
  17 fi
  18
  19 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join33.sql
  20 if [ $? -ne 0 ]
  21 then
  22   exit 1;
  23 fi
  24 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join_like.sql
  25 if [ $? -ne 0 ]
  26 then
  27   exit 1;
  28 fi
  29 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop_emp_dept.sql
  30 if [ $? -ne 0 ]
  31 then
  32   exit 1;
  33 fi