MySQL Bugs: #1198: mysql control center limits to 1000 records

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:	Windows (windows xp)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

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.