Re: LIMIT 0 hangs up in 4.0.1 - Michael Widenius - com.mysql.lists.bugs

6 messages in com.mysql.lists.bugsRe: LIMIT 0 hangs up in 4.0.1

From	Sent On	Attachments
Vladimir V. Kolpakov	06 Feb 2002 02:29
Vladimir V. Kolpakov	06 Feb 2002 02:29
Michael Widenius	06 Feb 2002 06:48
Vladimir V. Kolpakov	07 Feb 2002 00:37
Sasha Pachev	07 Feb 2002 11:27
Michael Widenius	08 Feb 2002 02:29

Subject:	Re: LIMIT 0 hangs up in 4.0.1
From:	Michael Widenius (mon...@mysql.com)
Date:	02/08/2002 02:29:02 AM
List:	com.mysql.lists.bugs

hi!

"Sasha" == Sasha Pachev <sas...@mysql.com> writes:

Sasha> On Thursday 07 February 2002 01:37 am, Vladimir V. Kolpakov wrote:

Thanks, Monty, It wasn't supposed to fix so quickly, because we need fix application to deal properly with rows_per_page=0 anyway. Will put severity "very very low" in to bug report next time :)

Sasha> In this case, severity is actually pretty high - anybody can crash the
server Sasha> with a query. Another reason is that while your application does not use Sasha> LIMIT 0 that often, many others do. So I am actually a bit concerned that Sasha> this bug was not reported earlier - it indicates that the reason we have
not Sasha> been getting too many bug reports in 4.0 is that not that many people are Sasha> trying it out on production type queries.

Note that this was not just LIMIT 0, it was:

SELECT without-from LIMIT 0

which is not something that one would normally do in a production environment.

Regards, Monty