*** empty log message ***
[csql.git] / test / tools / csql / test075.ksh
blob68dc25d137f03ee1c7f664e537a0f68d960128fa
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 update the records giving a condition and roll back, disconnect csql and and reconnect again. Check the changes made by update are not reflected on records
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}/autocommit11.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;