Bug #78874 ps_setup_show_enabled() shows too many objects
Submitted: 19 Oct 2015 17:05 Modified: 30 Jun 2016 17:17
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: SYS Schema Severity:S3 (Non-critical)
Version:5.7.9 OS:Any
Assigned to: CPU Architecture:Any

[19 Oct 2015 17:05] Paul DuBois
Description:
The sys schema ps_setup_show_enabled() procedure shows not just enabled objects but disabled ones.

How to repeat:
mysql> CALL sys.ps_setup_show_enabled(FALSE, FALSE);

...

+-------------+----------------------+---------+-------+
| object_type | objects              | enabled | timed |
+-------------+----------------------+---------+-------+
| EVENT       | mysql.%              | NO      | NO    |
| EVENT       | performance_schema.% | NO      | NO    |
| EVENT       | information_schema.% | NO      | NO    |
| EVENT       | %.%                  | YES     | YES   |
| FUNCTION    | mysql.%              | NO      | NO    |
| FUNCTION    | performance_schema.% | NO      | NO    |
| FUNCTION    | information_schema.% | NO      | NO    |
| FUNCTION    | %.%                  | YES     | YES   |
| PROCEDURE   | mysql.%              | NO      | NO    |
| PROCEDURE   | performance_schema.% | NO      | NO    |
| PROCEDURE   | information_schema.% | NO      | NO    |
| PROCEDURE   | %.%                  | YES     | YES   |
| TABLE       | mysql.%              | NO      | NO    |
| TABLE       | performance_schema.% | NO      | NO    |
| TABLE       | information_schema.% | NO      | NO    |
| TABLE       | %.%                  | YES     | YES   |
| TRIGGER     | mysql.%              | NO      | NO    |
| TRIGGER     | performance_schema.% | NO      | NO    |
| TRIGGER     | information_schema.% | NO      | NO    |
| TRIGGER     | %.%                  | YES     | YES   |
+-------------+----------------------+---------+-------+
20 rows in set (0.02 sec)

...

Suggested fix:
Don't show disabled objects.
[30 Jun 2016 17:17] Paul DuBois
Posted by developer:
 
Noted in 5.7.14 changelog.

ps_setup_show_enabled() showed disabled objects.