MySQL Bugs: #84869: Can not disable an engine

Bug #84869	Can not disable an engine
Submitted:	8 Feb 2017 1:15	Modified:	8 Feb 2017 8:31
Reporter:	aaron chan	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S3 (Non-critical)
Version:	5.7.17	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	disable, engine

Description:
the column "support" after executing command "show engines" can not reflect the "disabled" state:
mysql> show variables like '%disabled%'; 
+--------------------------+---------+ 
| Variable_name | Value | 
+--------------------------+---------+ 
| disabled_storage_engines | ARCHIVE | 
+--------------------------+---------+ 
1 row in set, 1 warning (0.00 sec) 
mysql> select support from information_schema.engines where engine='ARCHIVE'; 
+---------+ 
| support | 
+---------+ 
| YES | 
+---------+ 
1 row in set (0.02 sec)

How to repeat:
1、adding "disabled_storage_engines="ARCHIVE"" in config file
2、restart the server
3、connect server and execute "show engines;" command
4、check the "support" column value of engine ARCHIVE

Hello Aaron chan,

Thank you for the report and feedback!

Thanks,
Umesh