Bug #1364 MySQLCC Open Table returns only 1000 rows
Submitted: 21 Sep 2003 9:59 Modified: 8 Dec 2003 16:09
Reporter: Michael Dreher Email Updates:
Status: Closed Impact on me:
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.3 OS:Windows (WindowsXP)
Assigned to: Bugs System CPU Architecture:Any

[21 Sep 2003 9:59] Michael Dreher
When opening a table in MySQLCC only 1000 rows are returned when selecting "return all rows"  With "return limit" it funtions correctly and returns as many rows as asked for.

How to repeat:
either double click on the table name in the Console Manager or right-click the table name and select "Open Table" then "Return All Rows".  Only 1000 will be returned.
[21 Sep 2003 12:18] Sergei Golubchik
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Please see bug #1089.
[8 Dec 2003 16:09] Jorge del Conde

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