3 # 1. Create t1 table with 5 records in csql database.
4 # select t1.f1 from t1;
5 # select t1.notexist from t1;
8 # AUTHOR : Jitendra Lenka
10 QUITFILE
=${PWD}/sql
/Join
/quit.sql
14 REL_PATH
=`pwd`/sql
/Join
17 echo " select t1.f1 from t1;"
18 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1.sql
> /dev
/null
2>&1
24 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join1.sql
27 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
31 echo " select t1.notexist from t1;"
32 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join2.sql
35 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
40 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1