Bug #61029 Windows workbench gives false syntax errors for SP run on Linux
Submitted: 2 May 2011 18:45 Modified: 7 Jul 2011 11:35
Reporter: Peter O'Neill Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.33 and earlier OS:Windows (dbms on Linux)
Assigned to: CPU Architecture:Any
Tags: linux, stored procedure, syntax, workbench

[2 May 2011 18:45] Peter O'Neill
Description:
I had been trying to submit a stored procedure to MySQL running on a Red Hat Linux server from MySQL Workbench 5.2.33 running on Windows XP and got syntax warnings for every DECLARE statement even though my syntax was correct.  Transferring (by FTP) this SP from Windows to Linux and running it from the MySQL command line still failed for syntax error.

However, when I unpacked (gunzip) the SP on my Linux server and ran it from the command line there, it worked just fine.  The old MySQL Query Browser 1.2.17 on Windows says the syntax is fine and this SP also ran from Navicat on Windows.  So it appears that the Windows version of Workbench has a problem submitting SQL code to the Linux version of the MySQL database.

How to repeat:
Any stored procedure containing DECLARE statements created in MySQL Workbench on Windows to be run against MySQL database running on Linux.

Suggested fix:
Whatever you did to make this work in your old Query Browser. It might be the old newline vs. carriage return issue with text files in UNIX/Linux vs. Windows.    It would be interesting to see if Workbench works when also running on Linux.
[2 May 2011 21:07] MySQL Verification Team
Thank you for the bug report. You meant the mysql.exe tool client command has the same issue as Workbench too?. Thanks.
[2 May 2011 21:29] Peter O'Neill
No, I did not try the Windows MySQL command client.  I unzipped an SQL stored procedure mailed to my Windows machine by my database application vendor.  I opened this Windows file in my Windows MySQL Workbench and received the syntax error.  Even typing the SQL code directly into Workbench gave the same syntax error with Declare despite many experiments with syntax and delimiters. 

I FTPed the Windows file to the Linux server where I'm running MySQL (InnoDB engine) and tried to run it from the Linux MySQL command line and failed due to the same syntax error.  I finally succeeded by the vendor sending me the SQL stored procedure again, gunzipping it on my Linux server, and running it from the server's MySQL command line.  So it looks like a Windows/Linux incompatibility issue exists in both the command line (understandable) and Workbench (not understandable as a client that should run anywhere).

Thanks for looking into this.

Pete
[14 May 2011 10:28] Valeriy Kravchuk
What exact server version, 5.x.y, do you have on Linux? Please, upload code of some SP that demonstrates the problem for you.
[31 May 2011 17:03] Peter O'Neill
What exact server version, 5.x.y, do you have on Linux? 
Not being the system administrator,I don't know how to check this.  It was installed 12Dec2010.
[31 May 2011 17:07] Peter O'Neill
False syntax error for DECLARE statement

Attachment: InsertionValidation.txt (text/plain), 1.49 KiB.

[2 Jun 2011 17:06] Valeriy Kravchuk
Please, execute:

select version();

to find out exact server version.
[2 Jun 2011 21:09] Peter O'Neill
MySQL server version is 5.1.54-community on Red Hat Enterprise Linux.
[7 Jun 2011 11:35] MySQL Verification Team
Could you please try version 5.2.34 and if the issue continues please provide  an SP test case which cause the same issue reported. Thanks.
[7 Jul 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".