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: | |
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
[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".