MySQL Bugs: #80007: Error Parsing Valid Stored Procedure

Bug #80007	Error Parsing Valid Stored Procedure
Submitted:	15 Jan 2016 16:31	Modified:	18 May 2016 22:48
Reporter:	Joe Grasse (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.3.6	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
I am getting an error when trying to edit a valid stored procedure in Workbench 6.3.6. 

Error String: Error Parsing DDL for `test`.`test`

How to repeat:
CREATE DATABASE IF NOT EXISTS `test` /*!40100 DEFAULT CHARACTER SET latin1 */; 
USE test 
DROP TABLE IF EXISTS `order`; 
CREATE TABLE `order` ( 
`id` int(10) unsigned NOT NULL, 
`value` varchar(100) DEFAULT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

DROP PROCEDURE IF EXISTS test; 
delimiter $$ 
CREATE DEFINER=`root`@`localhost` PROCEDURE `test`() 
BEGIN 
SELECT * FROM test.order; 
END$$ 
delimiter ; 
INSERT INTO `order` VALUES (1,'test'); 
CALL test.test(); 

Now try to edit test.test in Workbench. 

Suggested fix:
Parse stored procedure successfully.

Hello Joseph Grasse,

Thank you for the report and test case.
Verified as described with WB 6.3.6 on Win7.

Thanks,
Umesh

I get the same error even I don't have a stored procedure but I have partitions.
https://bugs.mysql.com/bug.php?id=80506

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry:

Some stored procedure definitions were incorrectly reported as having
invalid syntax.

Thank you for the bug report.