Date: 2016-05-19 17:50:35 +0200
From: Richard Hughes <<richard.monetdb>>
To: SQL devs <>
Version: 11.21.19 (Jul2015-SP4)
CC: @njnes

Last updated: 2016-06-23 10:23:59 +0200

Comment 22156

Date: 2016-05-19 17:50:35 +0200
From: Richard Hughes <<richard.monetdb>>

Build is Jul2015 df58cfe6f8b9

Steps to reproduce:

root@mybox:~ monetdb create foobar
created database in maintenance mode: foobar
root@mybox:~ monetdb release foobar
taken database out of maintenance mode: foobar

In console 1:
$ mclient -h 127.0.0.1 -u monetdb foobar
sql>create user foo with password 'test' name 'foo' schema sys;
operation successful (43.508ms)
sql>select * from sys.sessions;
+---------+----------------------+------+----------------------+------+-------+
| user | login | sess | lastcommand | quer | activ |
: : : iont : : ytim : e :
: : : imeo : : eout : :
: : : ut : : : :
+=========+======================+======+======================+======+=======+
| monetdb | 2016-05-19 15:43:23. | 0 | 2016-05-19 15:44:06. | 0 | true |
: : 000000 : : 000000 : : :
+---------+----------------------+------+----------------------+------+-------+
1 tuple (12.965ms)

In console 2:
$ mclient -h 127.0.0.1 -u foo foobar
sql>

Back in console 1:
sql>select * from sys.sessions;
+---------+----------------------+------+----------------------+------+-------+
| user | login | sess | lastcommand | quer | activ |
: : : iont : : ytim : e :
: : : imeo : : eout : :
: : : ut : : : :
+=========+======================+======+======================+======+=======+
| monetdb | 2016-05-19 15:43:23. | 0 | 2016-05-19 15:44:27. | 0 | true |
: : 000000 : : 000000 : : :
| monetdb | 2016-05-19 15:44:23. | 0 | 2016-05-19 15:44:23. | 0 | false |
: : 000000 : : 000000 : : :
+---------+----------------------+------+----------------------+------+-------+
2 tuples (40.751ms)

Expected result:
The second query should show one row with user='monetdb' and one row with user='foo'.

Comment 22175

Date: 2016-05-24 23:47:37 +0200
From: @njnes

fixed in jul2015, ie don't pass a fixed string but use string from the client record.

Comment 22176

Date: 2016-05-24 23:49:26 +0200
From: @njnes

resolved in jun2016, as jun2015 didn't have the username field..

Comment 22177

Date: 2016-05-24 23:51:10 +0200
From: MonetDB Mercurial Repository <>

Changeset 6e6a6b6f4be1 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=6e6a6b6f4be1

Changeset description:

fixed bug #4011