6 messages in com.mysql.lists.bugsRe: LIMIT 0 hangs up in 4.0.1
FromSent OnAttachments
Vladimir V. Kolpakov06 Feb 2002 02:29 
Vladimir V. Kolpakov06 Feb 2002 02:29 
Michael Widenius06 Feb 2002 06:48 
Vladimir V. Kolpakov07 Feb 2002 00:37 
Sasha Pachev07 Feb 2002 11:27 
Michael Widenius08 Feb 2002 02:29 
Subject:Re: LIMIT 0 hangs up in 4.0.1
From:Vladimir V. Kolpakov (w@sfgate.com)
Date:02/07/2002 12:37:32 AM
List:com.mysql.lists.bugs

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 :) --w

On Wed, Feb 06, 2002 at 04:48:27PM +0200, Michael Widenius wrote:

"Vladimir" == Vladimir V Kolpakov <w@sfgate.com> writes:

Vladimir> Hi, Vladimir> It looks like "LIMIT 0" freeze SELECT against 4.0.1 server. Vladimir> I've checked out 4.0.2 changes list on mysql.com and seems to me Vladimir> it's not mentioned yet.

<cut>

Here is a patch for this (will be in 4.0.2).

===== sql_select.cc 1.149 vs edited ===== *** /tmp/sql_select.cc-1.149-17106 Thu Jan 31 04:36:58 2002 --- edited/sql_select.cc Wed Feb 6 18:18:19 2002 [...] Regards, Monty

--w