Re: mysql 4.0.1-alpha

2003-08-05 Thread Victoria Reznichenko
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > 7.5.5.2 Foreign Key Constraints > > Hi programmers, > > I try to code this > > CREATE TABLE EMPLOYEE > ( > FNAME VARCHAR(15) NOT NULL, > MINIT CHAR, > LNAME VARCHAR(15) NOT NULL, > SSN

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 *