MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

TRIGGER bug??
Posted by: Nitin Ahuja
Date: June 23, 2008 09:35PM

Create a new trigger for a table using the work bench and forward engineer to SQL script.
Make sure the Generate DROP TABLE option is checked.

The generated SQL has this statement

DELIMITER //

DROP TRIGGER IF EXISTS `schema_name`.`SYNTAX_ERROR_1` //

The SYNTAX_ERROR_1 is an obvious error but another bug might be the fact that the schema name is referred and not the table name. The newer version of MySQL
(> 5.0.2) is supposed to allow the use of table name to refer to the trigger.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
TRIGGER bug??
4109
Nitin Ahuja
June 23, 2008 09:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.