3 # create table t1(f1 int,f2 int,f3 int,primary key(f1));
4 # create table t2(f1 int,f2 int,f3 int,primary key(f1));
5 # Insert 5 records in each.
6 # Test "select min(nonexist.f1) from t1"
7 # Author : Jitendra Lenka
9 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
13 REL_PATH
=`pwd`/sql
/Aggregate
16 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2.sql
> /dev
/null
2>&1
23 echo "select min(nonexist.f1) from t1 :"
24 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggmin4.sql
28 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
33 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1