mirror of
https://github.com/MariaDB/server.git
synced 2025-07-26 05:04:59 +02:00
212fad1b7e
MTR .result files currently do not contain output to indicate if a change_user command has been executed in the corresponding .test files. Record change_user command in the following format in MTR output only if disable_query_log is set to false: change_user <user>,<password>,<db>; All new code of the whole pull request, including one or several files that are either new files or modified ones, are contributed under the BSD-new license. I am contributing on behalf of my employer Amazon Web Services, Inc.
61 lines
2 KiB
Text
61 lines
2 KiB
Text
# must return 0, 6
|
|
SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*)
|
|
FROM performance_schema.session_connect_attrs
|
|
WHERE ATTR_NAME IN ('_os', '_client_name', '_pid',
|
|
'_client_version', '_platform', 'program_name')
|
|
AND PROCESSLIST_ID = CONNECTION_ID();
|
|
SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
|
0 6
|
|
# must return 1
|
|
SELECT COUNT(DISTINCT PROCESSLIST_ID)
|
|
FROM performance_schema.session_connect_attrs;
|
|
COUNT(DISTINCT PROCESSLIST_ID)
|
|
1
|
|
# must return 0, 6
|
|
SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*)
|
|
FROM performance_schema.session_account_connect_attrs
|
|
WHERE ATTR_NAME IN ('_os', '_client_name', '_pid',
|
|
'_client_version', '_platform', 'program_name')
|
|
AND PROCESSLIST_ID = CONNECTION_ID();
|
|
SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
|
0 6
|
|
# must return 1
|
|
SELECT COUNT(DISTINCT PROCESSLIST_ID)
|
|
FROM performance_schema.session_account_connect_attrs;
|
|
COUNT(DISTINCT PROCESSLIST_ID)
|
|
1
|
|
CREATE USER wl5924@localhost;
|
|
connect non_privileged_user,localhost,wl5924,,"*NO-ONE*";
|
|
connection default;
|
|
# must return 1
|
|
SELECT COUNT(DISTINCT PROCESSLIST_ID)
|
|
FROM performance_schema.session_account_connect_attrs;
|
|
COUNT(DISTINCT PROCESSLIST_ID)
|
|
1
|
|
# must return 2
|
|
SELECT COUNT(DISTINCT PROCESSLIST_ID)
|
|
FROM performance_schema.session_connect_attrs;
|
|
COUNT(DISTINCT PROCESSLIST_ID)
|
|
2
|
|
connection non_privileged_user;
|
|
# must return 1
|
|
SELECT COUNT(DISTINCT PROCESSLIST_ID)
|
|
FROM performance_schema.session_account_connect_attrs;
|
|
COUNT(DISTINCT PROCESSLIST_ID)
|
|
1
|
|
SELECT COUNT(DISTINCT PROCESSLIST_ID)
|
|
FROM performance_schema.session_connect_attrs;
|
|
ERROR 42000: SELECT command denied to user 'wl5924'@'localhost' for table `performance_schema`.`session_connect_attrs`
|
|
connection default;
|
|
disconnect non_privileged_user;
|
|
grant select on performance_schema.* to wl5924@localhost;
|
|
change_user wl5924,,;
|
|
SELECT SUM(ISNULL(ATTR_VALUE)), COUNT(*)
|
|
FROM performance_schema.session_account_connect_attrs
|
|
WHERE ATTR_NAME IN ('_os', '_client_name', '_pid',
|
|
'_client_version', '_platform', 'program_name')
|
|
AND PROCESSLIST_ID = CONNECTION_ID();
|
|
SUM(ISNULL(ATTR_VALUE)) COUNT(*)
|
|
0 6
|
|
change_user root,,test;
|
|
DROP USER wl5924@localhost;
|