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:
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.3 beta OS:Windows (windows xp)
Assigned to: CPU Architecture:Any

[4 Sep 2003 12:53] Christopher Sherman
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

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.