MySQL Bugs: #1230: Open table - return all rows

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:	None
Category:	MySQLCC	Severity:	S3 (Non-critical)
Version:	0.9.3-beta	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any

Description:
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

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.

http://bugs.mysql.com/bug.php?id=1089

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.

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.

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.

Hi!

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