Changeset: 713b7097ea4e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=713b7097ea4e Modified Files: sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err sql/test/Users/Tests/grantMonetdb.stable.err sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err sql/test/Users/Tests/grantRole.Bug-3772.stable.err sql/test/Users/Tests/renameUser.stable.err sql/test/Users/Tests/role.stable.err sql/test/Users/Tests/role2.stable.err sql/test/Users/Tests/schema.stable.err Branch: Aug2018 Log Message:
Approve new error messages. diffs (131 lines): diff --git a/sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err b/sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err --- a/sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err +++ b/sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err @@ -30,12 +30,12 @@ stderr of test 'env_errors.Bug-3370` in MAPI = (monetdb) /var/tmp/mtest-12309/.s.monetdb.33326 QUERY = set role blah; -ERROR = !SQLException:sql.update_var:42000!Role (blah) missing -CODE = 42100 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 +ERROR = !Role (blah) missing +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-12403/.s.monetdb.39068 QUERY = set schema xyz; -ERROR = !SQLException:sql.update_var:3F000!Schema (xyz) missing -CODE = 42100 +ERROR = !Schema (xyz) missing +CODE = 3F000 # 09:53:02 > # 09:53:02 > "Done." diff --git a/sql/test/Users/Tests/grantMonetdb.stable.err b/sql/test/Users/Tests/grantMonetdb.stable.err --- a/sql/test/Users/Tests/grantMonetdb.stable.err +++ b/sql/test/Users/Tests/grantMonetdb.stable.err @@ -36,7 +36,7 @@ ERROR = !CREATE USER: access denied for CODE = M0M27 MAPI = (alice) /var/tmp/mtest-30274/.s.monetdb.37685 QUERY = GRANT sysadmin TO april; -ERROR = !Insufficient privileges to grant ROLE 'sysadmin' +ERROR = !GRANT: Insufficient privileges to grant ROLE 'sysadmin' CODE = 0P000 # 10:44:51 > diff --git a/sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err b/sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err --- a/sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err +++ b/sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err @@ -32,8 +32,8 @@ stderr of test 'grantMonetdbToSchemaOwne MAPI = (owner) /var/tmp/mtest-10039/.s.monetdb.37978 QUERY = set role monetdb; -ERROR = !SQLException:sql.update_var:42000!Role (monetdb) missing -CODE = 42100 +ERROR = !Role (monetdb) missing +CODE = 42000 # 16:37:25 > # 16:37:25 > "Done." 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 @@ -32,13 +32,13 @@ stderr of test 'grantRole.Bug-3772` in d MAPI = (bruce) /var/tmp/mtest-16480/.s.monetdb.37363 QUERY = GRANT role1 to bruce; -ERROR = !Insufficient privileges to grant ROLE 'role1' +ERROR = !GRANT: Insufficient privileges to grant ROLE 'role1' CODE = 0P000 MAPI = (bruce) /var/tmp/mtest-30274/.s.monetdb.37685 QUERY = SET role role1; -ERROR = !SQLException:sql.update_var:42000!Role (role1) missing -CODE = 42100 -MAPI = (bruce) /var/tmp/mtest-30274/.s.monetdb.37685 +ERROR = !Role (role1) missing +CODE = 42000 +MAPI = (bruce) /var/tmp/mtest-12671/.s.monetdb.35429 QUERY = select * from test; ERROR = !SELECT: access denied for bruce to table 's1.test' CODE = 42000 diff --git a/sql/test/Users/Tests/renameUser.stable.err b/sql/test/Users/Tests/renameUser.stable.err --- a/sql/test/Users/Tests/renameUser.stable.err +++ b/sql/test/Users/Tests/renameUser.stable.err @@ -36,9 +36,9 @@ ERROR = !DELETE FROM: insufficient privi CODE = 42000 MAPI = (april) /var/tmp/mtest-30274/.s.monetdb.37685 QUERY = SET role bankAdmin; -- no such role -ERROR = !SQLException:sql.update_var:42000!Role (bankadmin) missing -CODE = 42100 -MAPI = (april) /var/tmp/mtest-30274/.s.monetdb.37685 +ERROR = !Role (bankadmin) missing +CODE = 42000 +MAPI = (april) /var/tmp/mtest-12671/.s.monetdb.35429 QUERY = ALTER USER "april2" RENAME TO "april3"; --not enough privileges ERROR = !ALTER USER: no such user 'april2' CODE = 42M32 diff --git a/sql/test/Users/Tests/role.stable.err b/sql/test/Users/Tests/role.stable.err --- a/sql/test/Users/Tests/role.stable.err +++ b/sql/test/Users/Tests/role.stable.err @@ -36,12 +36,12 @@ ERROR = !DROP ROLE: no such role 'bankad CODE = 0P000 MAPI = (april) /var/tmp/mtest-30274/.s.monetdb.37685 QUERY = SET ROLE bankAdmin; -- role revoked -ERROR = !SQLException:sql.update_var:42000!Role (bankadmin) missing -CODE = 42100 -MAPI = (april) /var/tmp/mtest-30274/.s.monetdb.37685 +ERROR = !Role (bankadmin) missing +CODE = 42000 +MAPI = (april) /var/tmp/mtest-12671/.s.monetdb.35429 QUERY = SET ROLE bankAdmin2; -- role no longer exists -ERROR = !SQLException:sql.update_var:42000!Role (bankadmin2) missing -CODE = 42100 +ERROR = !Role (bankadmin2) missing +CODE = 42000 # 23:01:34 > # 23:01:34 > "Done." diff --git a/sql/test/Users/Tests/role2.stable.err b/sql/test/Users/Tests/role2.stable.err --- a/sql/test/Users/Tests/role2.stable.err +++ b/sql/test/Users/Tests/role2.stable.err @@ -81,8 +81,8 @@ stderr of test 'role2` in directory 'sql MAPI = my_user2@sofia:38256 QUERY = SET ROLE my_role; -ERROR = !SQLException:sql.update_var:42000!Role (my_role) missing -CODE = 42100 +ERROR = !Role (my_role) missing +CODE = 42000 # 20:38:25 > # 20:38:25 > Done. diff --git a/sql/test/Users/Tests/schema.stable.err b/sql/test/Users/Tests/schema.stable.err --- a/sql/test/Users/Tests/schema.stable.err +++ b/sql/test/Users/Tests/schema.stable.err @@ -12,7 +12,7 @@ stderr of test 'schema` in directory 'sq MAPI = (monetdb) /var/tmp/mtest-26250/.s.monetdb.37381 QUERY = GRANT my_owner to my_user; -- error wrong non existing role -ERROR = !Cannot grant ROLE 'my_owner' to ROLE 'my_user' +ERROR = !GRANT: Cannot grant ROLE 'my_owner' to user 'my_user' CODE = M1M05 # 14:00:57 > _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
