Testing IN operator in JOIN with non-existing field
[csql.git] / test / sql / Join / test019.ksh
blob504a17421a12164f568b2bf69a2eb298a4d5756c
1 #!/bin/sh
4 QUITFILE=${PWD}/sql/Join/quit.sql
5 REL_PATH=.
6 if [ -s "$QUITFILE" ]
7 then
8 REL_PATH=`pwd`/sql/Join
9 fi
11 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join34.sql
12 if [ $? -ne 0 ]
13 then
14 exit 1;
16 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/join_in_notexist.sql
17 if [ $? -ne 0 ]
18 then
19 exit 1;
21 $CSQL_INSTALL_ROOT/bin/csql -s $REL_PATH/drop_emp_dept.sql
22 if [ $? -ne 0 ]
23 then
24 exit 1;