Bug #62964 PROCEDURE analyse() not working if limit rows is enabled
Submitted: 27 Oct 2011 11:59 Modified: 9 Jan 2015 10:18
Reporter: Daniël van Eeden Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.35 CE OS:Any
Assigned to: CPU Architecture:Any

[27 Oct 2011 11:59] Daniël van Eeden
Description:
"SELECT * FROM SomeTable PROCEDURE analyse()" will only work if limit rows is disabled in the preferences.

How to repeat:
See description

Suggested fix:
Do not add "LIMIT 0,1000" when "procedure analyse()" is used.
[27 Oct 2011 16:34] Valeriy Kravchuk
Thank you for the bug report.
[27 Jul 2012 8:30] Philip Olson
Fixed as of Workbench 5.2.41, and here's the changelog entry:

A query such as "SELECT * FROM SomeTable PROCEDURE
analyse()" would only work if "limit rows" was
disabled in the preferences. The MySQL Workbench query parsing has
been extended to support this type of query.