12 messages in com.mysql.lists.bugsRE: optimizer bug: SELECT * FROM tbl_...
FromSent OnAttachments
von Boehn, Gunnar29 Aug 2002 08:33 
von Boehn, Gunnar29 Aug 2002 08:36 
von Boehn, Gunnar29 Aug 2002 08:37 
von Boehn, Gunnar29 Aug 2002 09:11 
Sinisa Milivojevic29 Aug 2002 09:58 
Michael Widenius02 Sep 2002 04:24 
Michael Widenius02 Sep 2002 04:58 
von Boehn, Gunnar02 Sep 2002 07:59 
Peter Zaitsev03 Sep 2002 03:29 
Michael Widenius03 Sep 2002 05:51 
Michael Widenius03 Sep 2002 06:02 
von Boehn, Gunnar03 Sep 2002 08:17 
Subject:RE: optimizer bug: SELECT * FROM tbl_name,tbl_name2 ... ORDER BY key LIMIT # uses filesort!
From:Sinisa Milivojevic (sin@mysql.com)
Date:08/29/2002 09:58:11 AM
List:com.mysql.lists.bugs

von Boehn, Gunnar writes:

Hi,

You told me that somebody has 'fixed' this problem in 4.0.3, who was it?

regards Gunnar

Monty did, but it was a case of SELECT DISTINCT .... ORDER BY ..

-- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sin@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com