Changeset: 3b22799d345f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3b22799d345f
Modified Files:
sql/test/Users/Tests/role2.stable.err
sql/test/Users/Tests/test_privs2_p2.stable.err
sql/test/Users/Tests/test_privs_p2.stable.err
Branch: default
Log Message:
Approve error codes.
diffs (83 lines):
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
@@ -82,6 +82,7 @@ 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
# 20:38:25 >
# 20:38:25 > Done.
diff --git a/sql/test/Users/Tests/test_privs2_p2.stable.err
b/sql/test/Users/Tests/test_privs2_p2.stable.err
--- a/sql/test/Users/Tests/test_privs2_p2.stable.err
+++ b/sql/test/Users/Tests/test_privs2_p2.stable.err
@@ -31,27 +31,35 @@ stderr of test 'test_privs2_p2` in direc
MAPI = (my_user2) /var/tmp/mtest-15225/.s.monetdb.34050
QUERY = SELECT * FROM version;
ERROR = !SELECT: access denied for my_user2 to table 'my_schema.version'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = insert into version (name ,i) values ('test2' ,2) ;
ERROR = !INSERT INTO: insufficient privileges for user 'my_user2' to insert
into table 'version'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = SELECT insertversion('test3', 3);
ERROR = !INSERT INTO: insufficient privileges for user 'my_user2' to insert
into table 'version'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = SELECT * FROM version;
ERROR = !SELECT: access denied for my_user2 to table 'my_schema.version'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = SELECT updateversion('test1', 4);
ERROR = !UPDATE: insufficient privileges for user 'my_user2' to update table
'version'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = SELECT * FROM version;
ERROR = !SELECT: access denied for my_user2 to table 'my_schema.version'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = SELECT deleteversion(4);
ERROR = !DELETE FROM: insufficient privileges for user 'my_user2' to delete
from table 'version'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = SELECT * FROM version;
ERROR = !SELECT: access denied for my_user2 to table 'my_schema.version'
+CODE = 42000
# 15:54:47 >
# 15:54:47 > "Done."
diff --git a/sql/test/Users/Tests/test_privs_p2.stable.err
b/sql/test/Users/Tests/test_privs_p2.stable.err
--- a/sql/test/Users/Tests/test_privs_p2.stable.err
+++ b/sql/test/Users/Tests/test_privs_p2.stable.err
@@ -31,15 +31,19 @@ stderr of test 'test_privs_p2` in direct
MAPI = (my_user2) /var/tmp/mtest-14654/.s.monetdb.35552
QUERY = select * from test;
ERROR = !SELECT: access denied for my_user2 to table 'my_schema.test'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = insert into test values(1,1);
ERROR = !INSERT INTO: insufficient privileges for user 'my_user2' to insert
into table 'test'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = update test set b = 2;
ERROR = !UPDATE: insufficient privileges for user 'my_user2' to update table
'test' on column 'b'
-MAPI = (my_user2) /var/tmp/mtest-13234/.s.monetdb.39382
+CODE = 42000
+MAPI = (my_user2) /var/tmp/mtest-28783/.s.monetdb.30417
QUERY = delete from test;
ERROR = !DELETE FROM: insufficient privileges for user 'my_user2' to delete
from table 'test'
+CODE = 42000
# 13:35:21 >
# 13:35:21 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
