2 #Test Case : DDL and DML operations in users other than root user
3 # Connect root user as:
4 # # csql -u root -p manager
5 # Create a user lakshya as:
6 # CSQL> create user lakshya password 'lakshya123';
7 # Connect csql through lakshya as
8 # # csql -u lakshya -p lakshya123
9 # Do DDL and DML operations. All should work properly.
11 QUITFILE
=${PWD}/tools
/UserStmt
/csql.conf
15 REL_PATH
=`pwd`/tools
/UserStmt
20 rm -f ${REL_PATH}/usr.sql ${REL_PATH}/usrlakshya.sql ${REL_PATH}/usrroot.sql
25 echo "echo create table t1(f1 int,f2 char(10));" >${REL_PATH}/usr.sql
26 echo "create table t1(f1 int,f2 char(10));" >>${REL_PATH}/usr.sql
27 echo "echo insert into t1 values(1,'root1');" >>${REL_PATH}/usr.sql
28 echo "insert into t1 values(1,'root1');" >>${REL_PATH}/usr.sql
29 echo "echo select * from t1;" >>${REL_PATH}/usr.sql
30 echo "select * from t1;" >>${REL_PATH}/usr.sql
31 echo "echo create user lakshya password 'lakshya123';" >>${REL_PATH}/usr.sql
32 echo "create user lakshya password 'lakshya123';" >>${REL_PATH}/usr.sql
33 echo "echo show users;" >>${REL_PATH}/usr.sql
34 echo "show users;" >>${REL_PATH}/usr.sql
35 echo "echo Disconnecting User root" >>${REL_PATH}/usr.sql
36 echo "quit;" >>${REL_PATH}/usr.sql
38 echo "echo create table t2(f1 int,f2 char(10));" >${REL_PATH}/usrlakshya.sql
39 echo "create table t2(f1 int,f2 char(10));" >>${REL_PATH}/usrlakshya.sql
40 echo "echo insert into t1 values(2,'root2');" >>${REL_PATH}/usrlakshya.sql
41 echo "insert into t1 values(2,'root2');" >>${REL_PATH}/usrlakshya.sql
42 echo "echo insert into t2 values(10,'lakshya');" >>${REL_PATH}/usrlakshya.sql
43 echo "insert into t2 values(10,'lakshya');" >>${REL_PATH}/usrlakshya.sql
44 echo "echo select * from t1;" >>${REL_PATH}/usrlakshya.sql
45 echo "select * from t1;" >>${REL_PATH}/usrlakshya.sql
46 echo "echo select * from t2;" >>${REL_PATH}/usrlakshya.sql
47 echo "select * from t2;" >>${REL_PATH}/usrlakshya.sql
48 echo "echo Disconnecting user lakshya" >>${REL_PATH}/usrlakshya.sql
49 echo "quit;" >>${REL_PATH}/usrlakshya.sql
51 echo "echo drop user lakshya;" >${REL_PATH}/usrroot.sql
52 echo "drop user lakshya;" >>${REL_PATH}/usrroot.sql
53 echo "drop table t1;" >>${REL_PATH}/usrroot.sql
54 echo "drop table t2;" >>${REL_PATH}/usrroot.sql
55 echo "quit;" >>${REL_PATH}/usrroot.sql
57 echo "Connecting User root"
58 if [ "$VALGRIND" = "true" ]
60 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usr.sql
62 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usr.sql
69 echo "Connecting User lakshya"
70 if [ "$VALGRIND" = "true" ]
72 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u lakshya
-p lakshya123
-s ${REL_PATH}/usrlakshya.sql
74 $CSQL_INSTALL_ROOT/bin
/csql
-u lakshya
-p lakshya123
-s ${REL_PATH}/usrlakshya.sql
81 echo "Connecting User root"
82 if [ "$VALGRIND" = "true" ]
84 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usrroot.sql
86 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/usrroot.sql