2 # Create two tables, having same fieldnames say f1,f2 in both the tables.
3 # Testing projection fieldname without tablename in joinint the two table.
4 # for ex : select f1 from t1,t2;
5 # select sum(f2) from t1,t2;
7 # Author : Jitendra Lenka
9 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
13 REL_PATH
=`pwd`/sql
/Aggregate
16 if [ "$VALGRIND" = "true" ]
18 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/nulltest1.sql
2> $0.valgr
20 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/nulltest1.sql
27 if [ "$VALGRIND" = "true" ]
29 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/projfield.sql
2>> $0.valgr
31 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/projfield.sql
34 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
39 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql