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