Bug #69687 PROCEDURE ANALYSE results in syntax error
Submitted: 8 Jul 2013 10:47 Modified: 20 Jul 2013 2:38
Reporter: Matthias Maier Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.0.2 OS:Windows (7 SP3)
Assigned to: CPU Architecture:Any
Tags: PROCEDURE ANALYSE, syntax error

[8 Jul 2013 10:47] Matthias Maier 
Description:
Since version 5.2.44 it is not possible to execute statements with PROCEDURE ANALYSE (http://dev.mysql.com/doc/refman/5.6/en/procedure-analyse.html). A syntax error (Error Code: 1064) is displayed. The reason seems to be the option 'limit rows' in workbench preferences -> sql queries -> query results

How to repeat:
Use a query like
SELECT col1, col2 FROM table1 PROCEDURE ANALYSE(10, 2000);
with enabled result limitation.

Suggested fix:
Disable the result limitation for all queries using PROCEDURE ANALYSE because   MySQL does not accept limit value as parameter.
[8 Jul 2013 10:58] MySQL Verification Team 
Hello Matthias,

Thank you for the bug report and the test case. 
Verified as described..

Thanks,
Umesh
[20 Jul 2013 2:38] Philip Olson 
Fixed as of the upcoming MySQL Workbench 6.0.4 release, and here's the changelog entry:

It was not possible to execute statements with the "PROCEDURE ANALYSE"
statement. 

A workaround was to remove the generated "LIMIT" clause.

Thank you for the bug report.