Changeset: 90e82511c01d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=90e82511c01d Added Files: sql/test/Users/Tests/metadataConsistency.sql sql/test/Users/Tests/metadataConsistency.stable.err sql/test/Users/Tests/metadataConsistency.stable.out Modified Files: sql/test/Users/Tests/All Branch: Nov2019 Log Message:
Add test to check meta data consistency after drop user command diffs (133 lines): diff --git a/sql/test/Users/Tests/All b/sql/test/Users/Tests/All --- a/sql/test/Users/Tests/All +++ b/sql/test/Users/Tests/All @@ -26,3 +26,4 @@ grantRole.Bug-3772 grantMonetdb copyinto schemaRights +metadataConsistency diff --git a/sql/test/Users/Tests/metadataConsistency.sql b/sql/test/Users/Tests/metadataConsistency.sql new file mode 100644 --- /dev/null +++ b/sql/test/Users/Tests/metadataConsistency.sql @@ -0,0 +1,30 @@ +create schema qdv; +set schema qdv; +select current_schema; + +create user "jtest" with unencrypted password 'wacht01' name 'Jan Test' schema "sys"; +declare jtest_id int; +select id into jtest_id from sys.auths where name = 'jtest'; +select jtest_id > 0; + +select privileges from sys.privileges where auth_id = jtest_id; + +create table abem (col1 int); +grant select on abem to "jtest"; +select privileges from sys.privileges where auth_id = jtest_id; + +grant insert, update, delete, truncate on abem to "jtest"; +select privileges from sys.privileges where auth_id = jtest_id; + +drop user "jtest"; +-- this should also remove the granted privileges in sys.privileges +select privileges from sys.privileges where auth_id = jtest_id; +-- should be empty + + +-- cleanup +drop table abem; +set schema sys; +select current_schema; +drop schema qdv; + diff --git a/sql/test/Users/Tests/metadataConsistency.stable.err b/sql/test/Users/Tests/metadataConsistency.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/Users/Tests/metadataConsistency.stable.err @@ -0,0 +1,12 @@ +stderr of test 'metadataConsistency` in directory 'sql/test/Users` itself: + + +# 14:51:39 > +# 14:51:39 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-648617" "--port=36823" +# 14:51:39 > + + +# 14:51:39 > +# 14:51:39 > "Done." +# 14:51:39 > + diff --git a/sql/test/Users/Tests/metadataConsistency.stable.out b/sql/test/Users/Tests/metadataConsistency.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/Users/Tests/metadataConsistency.stable.out @@ -0,0 +1,68 @@ +stdout of test 'metadataConsistency` in directory 'sql/test/Users` itself: + + +# 14:51:39 > +# 14:51:39 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-648617" "--port=36823" +# 14:51:39 > + +#create schema qdv; +#set schema qdv; +#select current_schema; +% .L2 # table_name +% L2 # name +% varchar # type +% 3 # length +[ "qdv" ] +#create user "jtest" with unencrypted password 'wacht01' name 'Jan Test' schema "sys"; +#declare jtest_id int; +#select id into jtest_id from sys.auths where name = 'jtest'; +#select jtest_id > 0; +% .L2 # table_name +% L2 # name +% boolean # type +% 5 # length +[ true ] +#select privileges from sys.privileges where auth_id = jtest_id; +% sys.privileges # table_name +% privileges # name +% int # type +% 1 # length +#create table abem (col1 int); +#grant select on abem to "jtest"; +#select privileges from sys.privileges where auth_id = jtest_id; +% sys.privileges # table_name +% privileges # name +% int # type +% 1 # length +[ 1 ] +#grant insert, update, delete, truncate on abem to "jtest"; +#select privileges from sys.privileges where auth_id = jtest_id; +% sys.privileges # table_name +% privileges # name +% int # type +% 2 # length +[ 1 ] +[ 4 ] +[ 2 ] +[ 8 ] +[ 64 ] +#drop user "jtest"; +#select privileges from sys.privileges where auth_id = jtest_id; +% sys.privileges # table_name +% privileges # name +% int # type +% 1 # length +#drop table abem; +#set schema sys; +#select current_schema; +% .L2 # table_name +% L2 # name +% varchar # type +% 3 # length +[ "sys" ] +#drop schema qdv; + +# 14:51:39 > +# 14:51:39 > "Done." +# 14:51:39 > + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
