Bug #1198 mysql control center limits to 1000 records
Submitted: 4 Sep 2003 12:53 Modified: 4 Sep 2003 17:54
Reporter: Christopher Sherman Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.3 beta OS:Microsoft Windows (windows xp)
Assigned to: CPU Architecture:Any

[4 Sep 2003 12:53] Christopher Sherman
Description:
Whe the user selects return all rows from the table the system limits the rows to 1000.  if you then limit the query with the limit command it will return all the rows.

This bug apeared after release 0.8.9 beta.

How to repeat:
to repeat open any table with more than 1000 rows.

Suggested fix:
change this function to realy return all rows.
[4 Sep 2003 17:54] Jorge del Conde
Hi!

You may change the limit size of the queries by editing the server connection and going to the "MySQL" tab.  Set the "Automatically limit SELECT queries to" 0 for unlimited or any other number you desire.