Bug #37214 use of "drop trigger if exists" on mysql server version 5.0.32
Submitted: 5 Jun 2008 5:54 Modified: 2 Apr 2009 12:42
Reporter: Lars Monecke Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.22 SE OS:Windows (XP 64)
Assigned to: CPU Architecture:Any

[5 Jun 2008 5:54] Lars Monecke 
Description:
We use mysql on a opensuse 10.2, where the latest version is 5.0.22. The Workbench use a syntax which is only support by 5.0.32. So Database syncronize and other commands fail.

How to repeat:
install mysql 5.0.22
create a table
create a trigger
syncronize db
change trigger
syncronize db
-> failure

Suggested fix:
check version of backen mysql server and use only supported features
[5 Jun 2008 18:19] Valeriy Kravchuk 
Thank you for a reasonable feature request. 

I do not consider it a bug though as 5.0.22 is ages old, released way before Workbench was created and just should not be used already...
[2 Apr 2009 12:41] Susanne Ebrecht 
Many thanks for writing a bug report.

MySQL Workbench only supports actual MySQL server releases.

When MySQL Workbench came out already MySQL 5.0.51. There is none support for lower versions.