MySQL Bugs: #53940: Triggers not showing in table editor

Bug #53940	Triggers not showing in table editor
Submitted:	24 May 2010 11:09	Modified:	3 Jun 2010 16:16
Reporter:	a b	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.21	OS:	Windows (XP)
Assigned to:	Sergei Tkachenko	CPU Architecture:	Any
Tags:	missing, trigger

Description:
I have a 5.0.27 MySQL database.

Some tables have triggers on them, which I can see by doing:
select * from information_schema.triggers;

But when I right-click one of these tables and go to Alter Table and click on the Triggers tab, I don't see them there, just this:
-- Trigger DDL Statements
DELIMITER $$

USE `cms_uat`$$

Maybe I'm missing something obvious? The tables are MyISAM. The triggers seem to work OK. They are quite complex with variables and multiple statements that insert data into other tables.

In information_schema.triggers, these columns have all NULL values:
TRIGGER_CATALOG, EVENT_OBJECT_CATALOG, ACTION_CONDITION, ACTION_REFERENCE_OLD_TABLE, ACTION_REFERENCE_NEW_TABLE, CREATED. Not sure if this is relevant or not.

How to repeat:
Not sure how to repeat it, or if it's just an idiosyncracy with my setup.

Just to add - the user I'm connecting as does have GRANT SUPER permissions on the table. Although I should be able to just view the trigger without it anyway, shouldn't I?

fix confirmed in repository

Changed category. This is Alter Table dialog in SQL Editor.

An entry has been added to the 5.2.22 changelog:

When a table containing triggers was loaded into the Alter Table dialog of SQL Editor, clicking on the Triggers tab showed an empty trigger, rather than the correct trigger code.