MySQL Bugs: #56644: MySQL Workbench does not support signal statement

Bug #56644	MySQL Workbench does not support signal statement
Submitted:	8 Sep 2010 13:01	Modified:	22 Jul 2012 18:28
Reporter:	Chong Hee Sia	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S1 (Critical)
Version:	5.2.27	OS:	Windows (XP Professional)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MySQL Workbench does not support signal statement in stored procedure.

How to repeat:
try using the signal statement in stored procedure

Indeed, Workbench reports syntax error while connected to 5.5.x if SIGNAL is used, but you can ignore that and create stored routine successfully.

This has been fixed as of the soon-to-be-released Workbench 5.2.42, and 
here's the changelog entry:

A signal statement in a stored procedure was not supported, and would
report a syntax error.