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

sys.sessions.user column always shows 'monetdb' #4011

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

sys.sessions.user column always shows 'monetdb' #4011

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

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant