Changeset: 8bd66f3f610a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8bd66f3f610a
Modified Files:
sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
sql/test/Users/Tests/grantRole.Bug-3772.stable.err
sql/test/Users/Tests/grantRole.Bug-3772.stable.out
Branch: default
Log Message:
approve output
diffs (72 lines):
diff --git a/sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
b/sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
--- a/sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
+++ b/sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
@@ -4,9 +4,7 @@
from util import sql_test_client
-sql_client = os.getenv('SQL_CLIENT')
-
-client('monetdb', 'monetdb', input = """\
+sql_test_client('monetdb', 'monetdb', input = """\
CREATE SCHEMA s1;
CREATE USER bruce WITH PASSWORD 'bruce' name 'willis' schema s1;
CREATE TABLE s1.test(d int);
@@ -15,7 +13,7 @@ GRANT ALL ON s1.test to role1;
""")
-client('bruce', 'bruce', input = """\
+sql_test_client('bruce', 'bruce', input = """\
GRANT role1 to bruce;
SET role role1;
select * from test;
diff --git a/sql/test/Users/Tests/grantRole.Bug-3772.stable.err
b/sql/test/Users/Tests/grantRole.Bug-3772.stable.err
--- a/sql/test/Users/Tests/grantRole.Bug-3772.stable.err
+++ b/sql/test/Users/Tests/grantRole.Bug-3772.stable.err
@@ -1,4 +1,4 @@
-stderr of test 'grantRole` in directory 'sql/test/Users` itself:
+stderr of test 'grantRole.Bug-3772` in directory 'sql/test/Users` itself:
# 22:31:48 >
@@ -26,15 +26,21 @@ stderr of test 'grantRole` in directory
# cmdline opt embedded_r = yes
# cmdline opt gdk_debug = 536870922
-# 22:31:49 >
-# 22:31:49 > "/usr/bin/python2" "grantRole.SQL.py" "grantRole"
-# 22:31:49 >
+# 22:00:19 >
+# 22:00:19 > "/usr/bin/python2" "grantRole.Bug-3772.SQL.py"
"grantRole.Bug-3772"
+# 22:00:19 >
-#GRANT role1 to bruce;
-# I imaine the error message should be something like this...
-GRANT: cannot grant ROLE 'role1' to ROLE/USER 'bruce'
+MAPI = (bruce) /var/tmp/mtest-16480/.s.monetdb.37363
+QUERY = GRANT role1 to bruce;
+ERROR = !GRANT: insufficient privileges to grant ROLE 'role1'
+MAPI = (bruce) /var/tmp/mtest-16480/.s.monetdb.37363
+QUERY = SET role role1;
+ERROR = !Role (role1) missing
+MAPI = (bruce) /var/tmp/mtest-16480/.s.monetdb.37363
+QUERY = select * from test;
+ERROR = !SELECT: access denied for bruce to table 's1.test'
-# 22:31:49 >
-# 22:31:49 > "Done."
-# 22:31:49 >
+# 22:00:20 >
+# 22:00:20 > "Done."
+# 22:00:20 >
diff --git a/sql/test/Users/Tests/grantRole.Bug-3772.stable.out
b/sql/test/Users/Tests/grantRole.Bug-3772.stable.out
--- a/sql/test/Users/Tests/grantRole.Bug-3772.stable.out
+++ b/sql/test/Users/Tests/grantRole.Bug-3772.stable.out
@@ -1,4 +1,4 @@
-stdout of test 'grantRole` in directory 'sql/test/Users` itself:
+stdout of test 'grantRole.Bug-3772` in directory 'sql/test/Users` itself:
# 22:31:48 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
