Cannot set role back to a user's default role

[monetdb-team]

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.