Bug #1089 Limited output from SELECT of 1000 records
Submitted: 19 Aug 2003 0:17 Modified: 21 Aug 2003 16:13
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
Category:MySQLCC Severity:S1 (Critical)
Version:0.9.2 OS:Microsoft Windows (Win2k)
Assigned to: Bugs System CPU Architecture:Any

[19 Aug 2003 0:17] [ name withheld ]
Any SELECT reports only the first 1000 records, if the option LIMIT is omitted.
Even if the output is inserted in another table or displayed.
To analyze measurement-data i've written some large SQL-scripts with Version 0.8 of MySQLCC and it works fine, but 0.9.2 reported wrong data, because some temporary tables counts only 1000 records, filled by select and LIMIT not given.

How to repeat:
Doubleclick on any large table (more than 1000 records) and see

Suggested fix:
Allow to to setup in MySQLCC-config, if output are limited or not.
[20 Aug 2003 23:53] Jorge del Conde

There is an option to disable the automatic LIMIT settings ... Edit the server and under 'MySQL Options' set 0 to the 'Automatically Limit SELECT queries to' spin-box.  The same applies for Maximum Join Size ... 0 is a special value that represents unlimited.
[26 Sep 2003 2:48] Pete Lettin
I admit this is very similar, but not quite the same and the fix does work.

But double clicking I would expect to return No. of rows as defined in Server Options but "Return All Rows" to me means ALL rows not just the amount the default limit setting.
[29 Dec 2003 0:57] [ name withheld ]
Sorry about submitting a duplicate bug report, Glancing through the titles, they didn't appear to be the same issue.  I will try and avoid repeats of that in the future.