test/sql/Join/test011.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # Create t11 table with 5 fields(f1,f2,f3,f4,f5)
   4 # Create t12 with 3 fields(f1,f2,f3)
   5 # Create t13 with 2 fields(f7,f8)
   6 # Insert 3 records in each.
   7 # (a)select f1,f7 from t12,t11;
   8 # (b)select t11.f1,t12.f7 from t13,t11;
   9
  10 # AUTHOR : Jitendra Lenka
  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
  20 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/tablet11t12t13.sql > /dev/null 2>&1
  21 if [ $? -ne 0 ]
  22 then
  23   exit 1;
  24 fi
  25
  26
  27
  28 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join11.sql
  29 if [ $? -ne 0 ]
  30   then
  31      $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt11t12t13.sql > /dev/null 2>&1
  32      exit 2;
  33 fi
  34
  35
  36
  37 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/dropt11t12t13.sql > /dev/null 2>&1
  38 exit 0;
  39