Bug #77821 No support for multiple triggers for one table having same event and action time

• Submitted: 23 Jul 2015 21:56
• Modified: 26 Jul 2015 10:25
• Reporter: Brad Lanier
• Status: Not a Bug
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: 6.3.4.0
• OS: Any
• CPU Architecture: Any
• Tags: multiple triggesr, table editor

[23 Jul 2015 21:56] Brad Lanier

Description:
When using the model table editor to create multiple triggers having the same event and action time, an error is generated stating that the server version (5.7.7-rc) does not support multiple triggers for one table having same event and action time.  The keywords PRECEDES and FOLLOWS are also not recognized.

How to repeat:
In the model table editor, attempt to create multiple triggers for one table having same event and action time.  Although you cannot do this directly, create the first one as BEFORE, a second one as AFTER, move the AFTER one up and modify to be a BEFORE.

[24 Jul 2015 7:01] Mike Lischke

Have you set the model version to 5.7.7? It works here when I do that.

[25 Jul 2015 21:43] Brad Lanier

Setting the model version did the trick. Not a bug.

It might be nice to have an option under Model Version to be "version of connected server", perhaps as the default?  Then use a specific model version to override.

[26 Jul 2015 10:25] Mike Lischke

This is what the server version in the general preferences is for. If you set specific settings for a model it uses those from the general settings.