Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

Mark T. Dame writes:
> mdame@pliedes-1.mfm.com 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
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php