3 #create table t1(f1 int not null,f2 int,f3 int);
4 #insert 5 records into t1. Test the following cases
5 #a) update t1 set f2=NULL;
6 #b) update t1 set f1=NULL;
7 #c) update t1 set f1=f1+f2+f3;
8 #d) UPDATE t1 SET f2=0 where f3>=1;
9 #e) DELETE FROM t1 WHERE f3>=4;
11 QUITFILE
=${PWD}/tools
/csql
/quit.sql
15 REL_PATH
=`pwd`/tools
/csql
18 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/null1.sql
21 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
24 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/null2.sql
27 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
30 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/null3.sql
33 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
36 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/null4.sql
39 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql
42 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/null5.sql
45 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop.sql