[EMAIL PROTECTED] writes: > >Description: > > Take two tables (call them a and b), which have identical structures. Table a > has no rows, table b has some (say 10) rows. If you do this: > > select * from a union select * from b limit 0,5 > > It works as expected. Now do this: > > select * from a union select * from b limit 5,5 > > Now you get _zero_ rows. In version 4.0.0, this worked as expected. >
Hi! Thank you for your bug report. This is a known bug and is already fixed. Fix will come up in 4.0.2 which should be out in two weeks or less. -- 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