Bug #38437 Validate All : Reports syntax errors without able to know where
Submitted: 29 Jul 2008 19:47 Modified: 15 May 2009 11:53
Reporter: Vincent Courcelle Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.23 OS:Windows
Assigned to: CPU Architecture:Any
Tags: errors, syntax, validate

[29 Jul 2008 19:47] Vincent Courcelle 
Description:
"Validate all" can report syntax errors, but it didn't say where does it founds those errors!

18:28:15 | Syntax error in trigger SYNTAX_ERROR_1

How to repeat:
Create a trigger with a syntax error, for example (missing a "THEN") :

CREATE TRIGGER test AFTER INSERT ON Table FOR EACH ROW
BEGIN
	IF TRUE
		
	END IF;
END;
//

Suggested fix:
Indicate the trigger signature, for example:

CREATE TRIGGER test AFTER INSERT ON Table FOR EACH ROW
[30 Jul 2008 3:51] Valeriy Kravchuk 
Thank you for a problem report.
[24 Feb 2009 11:00] Susanne Ebrecht 
This needs re-verifying with Workbench 5.1
[15 May 2009 11:53] Susanne Ebrecht 
Thank you for your bug report. This issue has already been fixed in Workbench 5.1, which you can download at

  http://www.mysql.com/downloads/