Bug #49310 Live editor limits to 1000 rows, no way to page further or define length?
Submitted: 1 Dec 2009 22:49 Modified: 25 Jun 2010 14:48
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.10 r4680 OS:Windows (XP)
Assigned to: Sergei Tkachenko CPU Architecture:Any

[1 Dec 2009 22:49] Todd Farmer
Description:
The live editor appears to limit the result sets to 1000 rows.  I cannot find that this is configurable in any way (not in preferences), which makes it impossible to view/edit data that exists beyond the 1000th row.

How to repeat:
Try live edit on a table with > 1000 rows.

Suggested fix:
Add support for pagination.
[1 Mar 2010 4:41] Terry Bailey
Given that there have been further releases, these may be new, but the Status is still Verified so thought I'd point these out.  This applies to the current version 5.2.16 

To remove the limit during query:
Go to preferences through the Edit | Preferences menu
Select the SQL Editor tab
Uncheck the "Limit Rows" checkbox in the Query Editor section and save with OK button

To raise / lower the limit during query:
Go to preferences through the Edit | Preferences menu
Select the SQL Editor tab
Change the value in the "Limit Rows Count:" input box from 1000 to your desired limit.

To retrieve the rest of the results when they have been limited:
The bottom of the results window shows a Fetched count and includes a "Fetch All" option.  
Click the "Fetch All" button to retrieve the rest of your results.
[25 Jun 2010 14:48] Mike Lischke
Fix already released.