List:General Discussion« Previous MessageNext Message »
From:Sinisa Milivojevic Date:October 23 2002 5:45pm
Subject:Re: Bug with Query in MySQL 4.0.4/RedHat 8.0
View as plain text  
Mark T. Dame writes:
> mdame@stripped wrote:
> > 
> > >Description:
> > 
> > This query produces 16 results:
> > 
> > SELECT * FROM table1
> > LEFT JOIN table2 ON (field1 = field2)
> > WHERE field2 = 'something'
> > ORDER BY field2,field3,field4
> > 
> > But this query produces 0 results:
> > 
> > SELECT * FROM table1
> > LEFT JOIN table2 ON (field1 = field2)
> > WHERE field2 = 'something'
> > ORDER BY field2,field3,field4
> > LIMIT 400;
> > 
> > I can also get the correct results set by removing the ORDER BY clause.
> > 
> > >How-To-Repeat:


Hi!

Thank you for your bug report.

This bug looks conspicuously like the bug we have fixed recently in
4.0.5 (still under development). 

This is the entry from the ChangeLog:


   * Fixed a newly introduced bug that caused `ORDER BY ... LIMIT #' to
     not return all rows.

You can check a fix by either waiting for 4.0.5 or by using our BK 4.0
repository.
-- 
Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com

Thread
GRANT/REVOKE wrong for tables?mlthomas11 Sep
  • GRANT/REVOKE wrong for tables?Michael Widenius16 Sep
  • Re: Bug with Query in MySQL 4.0.4/RedHat 8.0Sinisa Milivojevic23 Oct