MySQL Bugs: #76097: MySQL Workbench is case sensitive to find existing triggers linked to tables

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:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	triggers

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

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

Hello Equipe Système,

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

Thanks,
Umesh

// 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)

Screenshot..

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