MySQL Bugs: #66549: Object Browser do not show table triggers

Bug #66549	Object Browser do not show table triggers
Submitted:	27 Aug 2012 10:22	Modified:	13 Nov 2012 5:21
Reporter:	marcin.miga marcin.miga	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.42	OS:	Any (Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
In Object Browser I cant see created triggers. If I select  'Alter table' option, I can see it too. I know, it is, because it working and I see it in phpMyAdmin. I can create trigger in MySQL Worbench via SQL Editor.

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.42  revision 9752
Configuration Directory: C:\Users\Marcin.Miga\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
CPU: 4x Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 8.0 GiB RAM
Active video adapter (0): NVIDIA NVS 300 
Installed video RAM: 512 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.12.7628
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: Polish (Poland)

How to repeat:
mail

So, you had created trigger outside of Workbench (phpMyAdmin, command line or somehow else) and then you do not see it for the table. Please, confirm if this was the case. Had you tried to refresh (sub)tree in the object browser?

Some triggers I create in phpMyAdmin, some in MySQLWorbench via SQLEditor. And it works. But I can't see it. I don't try create triggers from ALTER TABLE window.
I try refresh, reconnect and close program - stil not see it.

I was able to repeat the problem on Mac OS X also. When trigger is created via Alter Table > Triggers tab, it is visible immediately. But if I create it in SQL Editor, for example, then even after numerous refreshes of the tree it is NOT visible. After Workbench restart on Mac OS X it is visible though...

Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

Lower level changes, such as a newly created "TRIGGER", would not be
visible after the object browser was refreshed.

Thank you for the bug report.

This is still not fixed

Shows trigger NOT showing in alter table tab

Attachment: NO_TRIGGERS.jpg (image/jpeg, text), 80.80 KiB.