Bug #97518 Workbench not showing triggers on table and cannot edit or delete it

• Submitted: 6 Nov 2019 16:40
• Modified: 27 Nov 2019 8:59
• Reporter: Francesco Auriemma
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 8.0.18
• OS: Windows (1903)
• CPU Architecture: Any

[6 Nov 2019 16:40] Francesco Auriemma

Description:
Triggers are enabled and work fine but it's visible only in schema treeview.

Attach screen of issue.

How to repeat:
When import dump into MySql 8 from 5.7, workbench not permit to view/edit triggers on tables.

[6 Nov 2019 16:41] Francesco Auriemma

Triggers

Attachment: Triggers not showing.png (image/png, text), 133.72 KiB.

[25 Nov 2019 5:51] MySQL Verification Team

Hello Francesco Auriemma,

Thank you for the bug report.
To investigate further this issue at our end, may I kindly request you to provide the MySQL dump from 5.7 for Drivers table with triggers? Thank you.

Regards,
Ashwini Patil

[26 Nov 2019 13:28] Francesco Auriemma

Dump exported from 5.7 database

Attachment: Dump20191126.sql (application/octet-stream, text), 12.26 KiB.

[27 Nov 2019 7:16] MySQL Verification Team

Hello Francesco Auriemma,

Thank you for providing the SQL dump.
I tried to reproduce your issue on windows 10 with workbench 8.0.18 using the SQL dump provided but I am not seeing any issues at my end. 

Regards,
Ashwini Patil

[27 Nov 2019 7:17] MySQL Verification Team

8.0.18 test results

Attachment: 97518_results.png (image/png, text), 492.85 KiB.

[27 Nov 2019 8:59] Francesco Auriemma

Hi,
my MySql 8 database is configured with option lower_case_table_names=2

I see in your screen that in your installation is case insensitive.

With case insensitive all work fine, but i can't set this option because non is supported by application.

kind regards
Francesco