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 * from a

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