Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.4
-
10.1.6-1
Description
MariaDB [test]> set global enforce_storage_engine=MyISAM;
|
ERROR 1228 (HY000): Variable 'enforce_storage_engine' is a SESSION variable and can't be used with SET GLOBAL
|
I truly hope it's an oversight, although from the last comment to MDEV-6858, it seems it might have been done on purpose. It's understandable why a super-user should be able to overrule it sometimes on the session level, but the main goal of it is still being a server-wide rule.
Attachments
Issue Links
- relates to
-
MDEV-6858 enforce_storage_engine option
-
- Closed
-
I decreased the priority because it turned out it can be set as a server startup option (it was not obvious right away due to
MDEV-8220).I still think it makes sense to allow it to be set globally, so I will keep it open; if there were really good reasons to prohibit it, please feel free to close as 'Won't fix'.
Please also document it as a server option, currently it's not there: https://mariadb.com/kb/en/mariadb/full-list-of-mariadb-options-system-and-status-variables/