Re: Mysql 4.0.1-Alpha: Union + Limit bug.

2002-03-22 Thread Sinisa Milivojevic
[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 *

Mysql 4.0.1-Alpha: Union + Limit bug.

2002-03-21 Thread eric
>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 y