Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot set role back to a user's default role #3364

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Cannot set role back to a user's default role #3364

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2013-09-20 00:52:01 +0200
From: Tim H. <<monetdb.bug.reporter>>
To: SQL devs <>
Version: 11.17.9 (Jan2014)
CC: @njnes

Last updated: 2015-08-28 13:42:51 +0200

Comment 19166

Date: 2013-09-20 00:52:01 +0200
From: Tim H. <<monetdb.bug.reporter>>

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36
Build Identifier:

sql>
+--------------+
| single_value |
+==============+
| monetdb |
+--------------+
sql>
Role (monetdb) missing

Reproducible: Always

Steps to Reproduce:

  1. Connect to the database as monetdb
  2. SQL: select current_role;
  3. SQL: set role "monetdb";

Actual Results:

+--------------+
| single_value |
+==============+
| monetdb |
+--------------+
1 tuple (1.250ms)
Role (monetdb) missing

Expected Results:

+--------------+
| single_value |
+==============+
| monetdb |
+--------------+
operation successful

The above example is contrived, but this issue affects any user who switches to a a different role and then wants to switch back to the default role.

Comment 21073

Date: 2015-08-01 15:17:34 +0200
From: MonetDB Mercurial Repository <>

Changeset 30d12a4105a0 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=30d12a4105a0

Changeset description:

Bug fixes

Bug #3759 fixed types of returned bats (ie use timestamps instead of lng) in modules/mal/clients.c
Bug #3769 fixed crash (triggered assert) by properly looking for referenced groupby columns in push aggr down
optimizer in rel_optimizer.c
Bug #3760 fixed correlated subquery handling in rel_select.c, ie merge only distinct expressions.
Bug #3761 fixed by properly adding the zero_or_one aggregation only when needed (ie when the cardinality of
the outer query is a column/table, ie when we expect one value per row for the subquery).
Bug #3364 fixed in sql_privileges.c, ie allow set role when role_id == auth_id (ie default role).
Bug #3365 fixed in sql_privileges.c, the sql_grant_table_privs always added 'all' privileges in one go
	       in rel_schema.c properly pass the login_id or role_id based on the 'from current_{role/user}'
		part of the grant statement
Bug #3476 was already fixed by previous revoke / schema fixes.

in gdk/gdk_select.c fixed problem with anti select and nils (stop before first nil instead of last)

Comment 21088

Date: 2015-08-01 16:26:27 +0200
From: MonetDB Mercurial Repository <>

Changeset 3b151fb999d8 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=3b151fb999d8

Changeset description:

added test for bug #3364

Comment 21089

Date: 2015-08-01 16:26:50 +0200
From: @njnes

allow resetting the default role

Comment 21218

Date: 2015-08-28 13:42:51 +0200
From: @sjoerdmullender

Jul2015 has been released.

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants