Bug #1157 Control Center 0.9.2 only working with 1000 records at a time.
Submitted: 28 Aug 2003 7:13 Modified: 8 Dec 2003 16:06
Reporter: Wolf Butler Email Updates:
Status: Closed Impact on me:
Category:MySQLCC Severity:S2 (Serious)
Version:0.9.2 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[28 Aug 2003 7:13] Wolf Butler
MySQLCC running on Windows.
Linux database, all recent versions.

When using MySQLCC (since ver. 0.9.1, from what I can tell), queries will only return 1000 records. Open Table options are set to open entire table, but will still only display 1000 records. This is also a problem in queries, because the number returned by any query is still being limited to 1000. 

This is a big problem when copying a table with "CREATE TABLE backup SELECT * FROM TABLE original" if the original table has more than 1000 records, the backup will not be complete. (If it wasn't for earlier backups, I would have lost hundreds of thousands of records because of this.)

It is acting like there is an implicit "limit 1000" at the end of any query, and I can't find anything about this being an option that can be manipulated. 

How to repeat:
Query any database larger than 1000 records. Try the above CREATE TABLE query. In my case- the backup table will never contain more than 1000 records.

Suggested fix:
If this is a configurable option- please let me know where it can be set and put it somewhere obvious in future releases. There seems to be very, very limited documentation on MySQLCC. This is an excellent product in all other regards.
[28 Aug 2003 7:16] Wolf Butler
Oops, please disregard the extra "TABLE" in my query example. Should be:
CREATE TABLE backup SELECT * FROM original
[28 Aug 2003 7:27] MySQL Verification Team
Please see bug #1089.
[28 Aug 2003 7:34] Wolf Butler
Sorry, did a search for this before posting and didn't see this one.

Thanks for the resolution.
[8 Dec 2003 16:06] 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.