Bug #76097 MySQL Workbench is case sensitive to find existing triggers linked to tables
Submitted: 2 Mar 2015 14:08 Modified: 3 Mar 2015 10:49
Reporter: Equipe Système Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.2, 6.2.4 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: triggers

[2 Mar 2015 14:08] Equipe Système
Description:
Only triggers that have a table reference in lower case are visible in the Triggers Tab.

How to repeat:
How to reproduce the bug:
1. Create a table named TEST
2. Create a trigger on this table : CREATE TRIGGER test_AFTER_INSERT AFTER INSERT ON TEST FOR EACH ROW BEGIN END;
3. In MySQL Workbench this trigger is not visible in the Triggers Tab of the new table TEST
4. But it exists if we do: SELECT * FROM information_schema.TRIGGERS;

However, we replace the point 2 by:
2. Create a trigger on this table : CREATE TRIGGER xxx AFTER INSERT ON test FOR EACH ROW BEGIN END; /*Note the table name in lower case*/
Then:
3. In MySQL Workbench this trigger is visible in the Triggers Tab
[2 Mar 2015 14:50] Peter Laursen
Trigger names in MySQL are case sensitive if file system on the server is case sensitive. Are you connected to a server running on Linux (for instance) or is it a local server on Windows? 

-- Peter
-- not a MySQL/Oracle person
[3 Mar 2015 10:49] Umesh Shastry
Hello Equipe Système,

Thank you for the report.
Observed this issue when MYSQL server was hosted on windows host.

Thanks,
Umesh
[3 Mar 2015 10:52] Umesh Shastry
// How to repeat ( Repeated only on Win7 with WB 6.2.4 )

use test;
create table TEST(id int not null);
CREATE TRIGGER test_AFTER_INSERT AFTER INSERT ON TEST FOR EACH ROW BEGIN END;

// Try to confirm if trigger exists

Right click on table->Alter Table-> Triggers (TAB) 
^^ trigger is not listed

Where as if you navigate from schemas->test->tables->test->triggers <-- trigger is listed (also, you can confirm the same with information_schema.TRIGGERS)
[3 Mar 2015 10:53] Umesh Shastry
Screenshot..

Attachment: 76097.png (image/png, text), 47.26 KiB.