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