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
