MySQL Bugs: #84882: information_schema.engines should show if an engine is disabled

Bug #84882	information_schema.engines should show if an engine is disabled
Submitted:	8 Feb 2017 11:15	Modified:	13 Feb 2017 12:32
Reporter:	Morgan Tocker	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	8.0.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
There is no way from information_schema to tell if an engine is in the disabled_storage_engines list.

How to repeat:
mysql [localhost] {msandbox} ((none)) > show global variables like 'disabled_storage_engines';
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| disabled_storage_engines | archive |
+--------------------------+---------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} ((none)) > SELECT * from information_schema.engines where engine='ARCHIVE'\G
*************************** 1. row ***************************
      ENGINE: ARCHIVE
     SUPPORT: YES
     COMMENT: Archive storage engine
TRANSACTIONS: NO
          XA: NO
  SAVEPOINTS: NO
1 row in set (0.00 sec)

Suggested fix:
Add a new column to output for DISABLED?

Hello Morgan,

Thank you for the report and feature request!

Thanks,
Umesh