Bug #3684 MYCC 9.4 only returns 1000 rows from 'Return All Rows'

• Submitted: 6 May 2004 22:39
• Modified: 6 May 2004 23:41
• Reporter: Asdf asdf
• Status: Not a Bug
• Category: MySQLCC
• Severity: S2 (Serious)
• Version: 0.9.4
• OS: Windows (Windows 2000)
• Assigned to: Dean Ellis
• CPU Architecture: Any

[6 May 2004 22:39] Asdf asdf

Description:
Running a query, or clicking 'Return all rows' only returns 1000 rows.

How to repeat:
1. Go to MySQL Servers window pane.
2. Expand server
3. Expand database
4. select table.
5. Right click, and select 'Return all rows'
6. Only 1000 rows are selected.

Workaround: run query with limit greater than total number of rows in table. 

i.e. Select * from mytable limit 100000

Suggested fix:
Cause query to retun all rows. Also would be nice to be able to set default limit in the MyCC configuration.

[6 May 2004 23:41] Dean Ellis

Go to your server properties and change "Automatically limit SELECT queries" to 0/Unlimited.