Mark T. Dame writes:
> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
