test/sql/Join/test014.ksh

   1 #!/bin/ksh
   2 #Testing BETWEEN operator in Join
   3 #create table emp(eno int,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.dno between 10 and 30;
   8 #select * from emp,dept where dept.deptno between 20 and 40;
   9 #select * from emp,dept where emp.dno between 15 and 30  and dept.deptno between 20 and 40;
  10 #select * from emp,dept where emp.dno between 15 and 30 or dept.deptno between 20 and 40;
  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/join32.sql
  20 if [ $? -ne 0 ]
  21 then
  22   exit 1;
  23 fi
  24 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join_between.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