Changeset: 4d8e6f50bcf8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4d8e6f50bcf8 Modified Files: sql/test/Users/Tests/create_user_options.test Branch: Sep2022 Log Message:
Approve test results. It is allowed that when creating a user it implicitly also creates a new schema if no SCHEMA ... is provided. diffs (80 lines): diff --git a/sql/test/Users/Tests/create_user_options.test b/sql/test/Users/Tests/create_user_options.test --- a/sql/test/Users/Tests/create_user_options.test +++ b/sql/test/Users/Tests/create_user_options.test @@ -106,24 +106,20 @@ drop user testu09 statement ok drop role testR1 -statement ok +statement error M1M05!DROP USER: 'testu08b' owns a schema drop user testu08b --- it should be possible to drop a successful created user but instead I get: error M1M05!DROP USER: 'testu08b' owns a schema statement error 0P000!DROP USER: no such user role 'testu08a' drop user testu08a -statement ok +statement error M1M05!DROP USER: 'testu07' owns a schema drop user testu07 --- it should be possible to drop a successful created user but instead I get: error M1M05!DROP USER: 'testu07' owns a schema -statement ok +statement error M1M05!DROP USER: 'testu06' owns a schema drop user testu06 --- it should be possible to drop a successful created user but instead I get: error M1M05!DROP USER: 'testu06' owns a schema -statement ok +statement error M1M05!DROP USER: 'testu05b' owns a schema drop user testu05b --- it should be possible to drop a successful created user but instead I get: error M1M05!DROP USER: 'testu05b' owns a schema statement error 0P000!DROP USER: no such user role 'testu05a' drop user testu05a @@ -131,9 +127,8 @@ drop user testu05a statement ok drop user testu04 -statement ok +statement error M1M05!DROP USER: 'testu03' owns a schema drop user testu03 --- it should be possible to drop a successful created user but instead I get: error M1M05!DROP USER: 'testu03' owns a schema statement error 0P000!DROP USER: no such user role 'testu02' drop user testu02 @@ -142,7 +137,7 @@ statement error 0P000!DROP USER: no such drop user testu01 --- strangely some create user statements also create a schema implicitly !!! show them +-- note: create user statements without SCHEMA ... also create a schema implicitly !!! show them query TII rowsort select name, authorization > 3, owner > 3 from sys.schemas where not system and name like 'test%' order by name ---- @@ -169,16 +164,14 @@ 0 statement ok alter user testu03 set schema sys -statement ok +statement error M1M05!DROP USER: 'testu03' owns a schema drop user testu03 --- it does not work, after: alter user testu03 set schema sys statement ok alter user testu03 schema path '"sys"' -statement ok +statement error M1M05!DROP USER: 'testu03' owns a schema drop user testu03 --- it still does not work, after: alter user testu03 schema path '"sys"' -- try to drop the schema first statement ok @@ -187,7 +180,7 @@ drop schema testu03 statement ok drop user testu03 --- finally it works +-- finally the created user (and implictly created schema) can be dropped statement error 2BM37!DROP SCHEMA: unable to drop schema 'testu05b' (there are database users using it as session's default schema) drop schema testu05b _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
