MySQL Bugs: #26415: Show TRIGGERs in object list

Bug #26415	Show TRIGGERs in object list
Submitted:	15 Feb 2007 17:09	Modified:	11 Mar 2009 11:26
Reporter:	Sebastien Caisse	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S4 (Feature request)
Version:	1.2.12, 1.2.9rc	OS:	Windows (Windows XP Pro, sp2)
Assigned to:		CPU Architecture:	Any

Description:
Triggers don't show up in any fashion other than looking at information_schema TABLE or using SHOW TRIGGERS; would be nice to see them in the interface - I would think preferably with the TABLE rather than with the schema as the TABLEs and FUNCTIONs end up being rather numerous..

I noticed Bug #16938 which mentions it has it's own icon which I find weird since I don't see them at all - maybe it's a bug on my query browser? Or maybe I've failed to understand how they should be displayed?

How to repeat:
DROP TABLE IF EXISTS `test`;
CREATE TABLE  `test` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
);

CREATE TRIGGER testtrig BEFORE INSERT ON test
 FOR EACH ROW SET @sum = @sum + NEW.id;

See how there's no trigger displayed...

Wronf severity

Thank you for a reasonable feature request.

Bug #27163 was marked as a duplicate of this one.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/