Bug #1230 Open table - return all rows - limits to 1000
Submitted: 9 Sep 2003 1:37 Modified: 8 Dec 2003 16:04
Reporter: Bernhard Schmidt Email Updates:
Status: Closed Impact on me:
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.3-beta OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[9 Sep 2003 1:37] Bernhard Schmidt
The open table command "return all rows" returns only the first 1000 
- like the default as for "Limit Rows"

How to repeat:
every time

Suggested fix:
remove the limit
[9 Sep 2003 1:53] 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.

[9 Sep 2003 2:31] Bernhard Schmidt
i don't agree, that this bug is duplicate to #1089.

my alternate front-end "MYSQL-Front" shows me that the output isn't truncated by the Server but by mysqlcc.

#1089 is about the server working on data.

My Report is about mysqlCC limiting the select, when the command clearly states, the the command stays unlimited.
[9 Sep 2003 3:19] Sergei Golubchik
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.
[9 Sep 2003 3:53] Bernhard Schmidt
mysqlcc gave the user 2 options to edit an table
- return all rows
- return limit

i feel really - in german "verarscht" - when an developer states, 
that "return all rows" means to dig in configuration files.

the command says "return all rows" - without any limit anywhere,
because when i want any limit, i would have to use "return limit".

It would be ok, when the config default is applied the explizit sql commands,
but not for the "open table"-resultset.

This is an bug, at least in the user interfaces
When the config files count more that the explizit user command,
then the user command has to be changed to "open table" alone.
[8 Dec 2003 16:04] Jorge del Conde

Edit the server properties and under the "MySQL Options" tab change the limit settings to 0 for unlimited.