Bug #79698 Invalid Error Detection
Submitted: 18 Dec 2015 6:51 Modified: 18 Dec 2015 7:28
Reporter: Josef Fuchs Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:6.2.3 OS:Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[18 Dec 2015 6:51] Josef Fuchs
Description:
When trying to change a stored procedure the editor recognizes an SQL error that does not exist. The SQL procedure is already stored in database.

Connected to a MySQL Community Server 5.5.13

How to repeat:
CREATE DEFINER=`root`@`%` PROCEDURE `bogen_common`(IN `vorgangNr` INT(11))
    READS SQL DATA
BEGIN
	/* Daten aus KALK_PROD (AA) je Druckbogen 1 Zeile */
	DROP TABLE IF EXISTS tmp_bogen_nr;
	CREATE TEMPORARY TABLE tmp_bogen_nr
	SELECT REF_VORGAENGE, 
	       db_bogennr,
	       0+anz_farben AS farb_oben,

THE LINE BELOW IS MAREKED AS AN ERROR BUT IS WORKING WELL
=========================================================
	       0+RIGHT(anz_farben, LENGTH(anz_farben)-LOCATE('/',anz_farben)) AS farb_unten,

	       pt_typbez,
	       pteil_nam,
	       IF (   pteil_nam LIKE '%Umschlag%' 
...
[18 Dec 2015 7:28] MySQL Verification Team
Hello Josef Fuchs,

Thank you for the report.
I'm not seeing this issue with WB 6.3.6 on Win7. Could you please confirm if you are seeing this issue with WB 6.3.6? If yes, then please provide screenshot and/or stored procedure to confirm this issue at our end too.

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Umesh