database/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-07 00:04:31 +03:00
Code Activity
Files
MDEV-36812
mariadb/mysql-test/suite/roles
History
Dmitry Shulga ce7ab467db MDEV-35617: DROP USER should leave no active session for that user 
DROP USER looks for sessions by the do-be-dropped user and if found:
* fails with ER_CANNOT_USER in Oracle mode
* continues with ER_ACTIVE_CONNECTIONS_FOR_USER_TO_DROP warning otherwise

Every user being dropped is marked with flag that disallow establishing
a new connections on behalf this user.
2025-07-16 09:14:33 +07:00
..
acl_load_mutex-5170.result
Fixed failing test acl_load_mutex-5170
2018-06-19 16:23:34 +03:00
acl_load_mutex-5170.test
MDEV-23511 shutdown_server 10 times out, causing server kill at shutdown
2020-08-21 14:48:53 +03:00
acl_statistics.opt
Updated mtr files to support different compiled in options
2019-09-01 19:17:35 +03:00
acl_statistics.result
Merge 10.10 into 10.11
2023-10-17 16:04:21 +03:00
acl_statistics.test
Fix typos in mysql-test/
2025-04-29 13:53:16 +10:00
admin.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
admin.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
create_and_drop_current.result
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
create_and_drop_current.test
MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be stopped with no-zero size)
2015-09-04 10:33:56 +02:00
create_and_drop_role_invalid_user_table.result
MDEV-27743 Remove Lex::charset
2022-03-22 17:12:15 +04:00
create_and_drop_role_invalid_user_table.test
12.0 branch
2025-02-12 12:37:38 +01:00
create_and_drop_role.result
fix error messages
2025-05-02 13:56:25 +02:00
create_and_drop_role.test
MDEV-11533: Roles with trailing white spaces are not cleared correctly
2016-12-10 22:23:25 +02:00
create_and_grant_role.result
MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE
2021-07-09 08:25:54 +02:00
create_and_grant_role.test
…
current_role_view-12666.result
Merge branch '10.1' into 10.2
2017-07-05 19:08:55 +02:00
current_role_view-12666.test
MDEV-12666: CURRENT_ROLE() and DATABASE() does not work in a view
2017-06-15 19:20:35 +03:00
default_create_user_not_role.result
MDEV-17658 change the structure of mysql.user table
2018-12-12 00:31:44 +01:00
default_create_user_not_role.test
…
definer.result
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
definer.test
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
drop_current_role.result
Merge branch '10.1' into 10.2
2020-08-02 11:05:29 +02:00
drop_current_role.test
improve the error message for a dropped current role
2020-07-30 23:50:56 +02:00
drop_current_user-5176.result
MDEV-35617: DROP USER should leave no active session for that user
2025-07-16 09:14:33 +07:00
drop_current_user-5176.test
MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be stopped with no-zero size)
2015-09-04 10:33:56 +02:00
drop_routines.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
drop_routines.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
flush_roles-12366.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
flush_roles-12366.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
flush_roles-17898.result
MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE
2021-07-09 08:25:54 +02:00
flush_roles-17898.test
Merge 10.3 into 10.4
2019-04-03 11:43:39 +03:00
grant_empty.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
grant_empty.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
grant_proxy-5526.result
MDEV-20076: SHOW GRANTS does not quote role names properly
2020-02-05 17:22:26 +01:00
grant_proxy-5526.test
…
grant_revoke_current.result
fix error messages
2025-05-02 13:56:25 +02:00
grant_revoke_current.test
fix error messages
2025-05-02 13:56:25 +02:00
grant_role_auto_create_user.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
grant_role_auto_create_user.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
grant-5771.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
grant-5771.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
i_s_applicable_roles_is_default.result
MDEV-12484 Enable unix socket authentication by default
2019-02-12 19:14:37 +01:00
i_s_applicable_roles_is_default.test
MDEV-12484 Enable unix socket authentication by default
2019-02-12 19:14:37 +01:00
ip-6401.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
ip-6401.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
none_public.result
compare public_name by pointer
2022-11-02 00:25:55 +01:00
none_public.test
MDEV-5215 post-review fixes
2022-11-01 22:20:02 +01:00
password.result
MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be stopped with no-zero size)
2015-09-04 10:33:56 +02:00
password.test
MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be stopped with no-zero size)
2015-09-04 10:33:56 +02:00
prepare_stmt_with_role.result
MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE
2021-07-09 08:25:54 +02:00
prepare_stmt_with_role.test
MDEV-9443: Add reexecution test cases.
2016-03-22 22:21:04 +02:00
ps.result
…
ps.test
…
rebuild_role_grants.result
Merge 10.2 into 10.3
2021-10-21 13:41:04 +03:00
rebuild_role_grants.test
MDEV-17964: Assertion `status == 0' failed in add_role_user_mapping_action
2021-10-15 19:19:36 +03:00
recursive_dbug.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
recursive_dbug.test
…
recursive.inc
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
recursive.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
recursive.test
…
rename_user.result
Merge branch '10.3' into 10.4
2022-08-02 14:15:39 +02:00
rename_user.test
MDEV-29131 Assertion `status == 0' failed when renaming user after deleting table roles_mapping
2022-07-29 21:58:38 +02:00
revoke_all.result
MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE
2021-07-09 08:25:54 +02:00
revoke_all.test
…
role_case_sensitive-10744.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
role_case_sensitive-10744.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
role_grant_propagate.result
MDEV-30526 Assertion `rights == merged->cols' failed in update_role_columns
2023-02-21 23:22:56 +01:00
role_grant_propagate.test
MDEV-30526 Assertion `rights == merged->cols' failed in update_role_columns
2023-02-21 23:22:56 +01:00
roles_tables_priv-29465.result
Merge branch '10.3' into 10.4
2022-10-01 23:07:26 +02:00
roles_tables_priv-29465.test
MDEV-29465: Inherited columns privs for roles wrongly set mysql.tables_priv column
2022-09-14 14:40:50 +03:00
rpl_definer.result
MDEV-19123 Change default charset from latin1 to utf8mb4
2024-07-11 10:21:07 +04:00
rpl_definer.test
MDEV-6720 - enable connection log in mysqltest by default
2016-03-31 10:11:16 +04:00
rpl_grant_revoke_current_role-8638.result
Post-merge: Update test results
2016-06-30 23:56:18 -04:00
rpl_grant_revoke_current_role-8638.test
include/master-slave.inc must always be included last
2017-09-20 18:17:50 +02:00
set_and_drop.result
MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB
2022-09-30 08:48:57 +02:00
set_and_drop.test
…
set_default_role_clear.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_default_role_clear.test
…
set_default_role_for.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_default_role_for.test
MDEV-17658 change the structure of mysql.user table
2018-12-12 00:31:44 +01:00
set_default_role_invalid_skip_name_resolve-master.opt
MDEV-26875: Wrong user in SET DEFAULT ROLE error
2023-10-30 18:39:56 +01:00
set_default_role_invalid_skip_name_resolve.result
MDEV-26875: Wrong user in SET DEFAULT ROLE error
2023-10-30 18:39:56 +01:00
set_default_role_invalid_skip_name_resolve.test
MDEV-26875: Wrong user in SET DEFAULT ROLE error
2023-10-30 18:39:56 +01:00
set_default_role_invalid.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_default_role_invalid.test
MDEV-26875: Wrong user in SET DEFAULT ROLE error
2023-10-30 18:39:56 +01:00
set_default_role_new_connection.result
Merge branch '10.3' into 10.4
2022-10-01 23:07:26 +02:00
set_default_role_new_connection.test
…
set_default_role_ps-6960.result
MDEV-17658 change the structure of mysql.user table
2018-12-12 00:31:44 +01:00
set_default_role_ps-6960.test
MDEV-31005: Make working cursor-protocol
2024-09-18 18:39:26 +07:00
set_role-5232.result
MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB
2022-09-30 08:48:57 +02:00
set_role-5232.test
…
set_role-9614.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
set_role-9614.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
set_role-13655.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
set_role-13655.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
set_role-database-recursive.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_role-database-recursive.test
…
set_role-database-simple.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_role-database-simple.test
…
set_role-multiple-role.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_role-multiple-role.test
…
set_role-recursive.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_role-recursive.test
…
set_role-routine-simple.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_role-routine-simple.test
…
set_role-simple.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
set_role-simple.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
set_role-table-column-priv.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_role-table-column-priv.test
…
set_role-table-simple.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
set_role-table-simple.test
…
show_create_database-10463.result
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
show_create_database-10463.test
cleanup: disconnect before DROP USER
2025-07-16 09:14:33 +07:00
show_grants_replicated.result
MDEV-26080: SHOW GRANTS does not quote role names properly for DEFAULT ROLE
2021-07-09 08:25:54 +02:00
show_grants_replicated.test
MDEV-6720 - enable connection log in mysqltest by default
2016-03-31 10:11:16 +04:00
show_grants.result
MDEV-36397 Record change_user command in MTR output
2025-06-23 20:38:36 +02:00
show_grants.test
MDEV-24289: show grants missing with grant option
2020-11-26 18:10:40 +01:00