adding test scripts
[csql.git] / test / tools / csql / test081.ksh
blobb4f3106c429357df7e6a66dad6d391b71dbc139c
1 #!/bin/ksh
2 #Test case
3 #Autocommit mode off
4 #create table t1(f1 int,f2 int);
5 #insert 4 records into table t1 and commit. Then delete the records giving a condition and roll back, disconnect csql and and reconnect again. Check all the inserted records are there. No record is deleted
7 QUITFILE=${PWD}/tools/csql/quit.sql
8 REL_PATH=.
9 if [ -s "$QUITFILE" ]
10 then
11 REL_PATH=`pwd`/tools/csql
14 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/autocommit17.sql
15 if [ $? -ne 0 ]
16 then
17 exit 1;
19 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/quit.sql
20 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/selectstar.sql
21 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop.sql
22 if [ $? -ne 0 ]
23 then
24 exit 1;