select on varchar

[Arnoud]

Hi,

I have 2 tables. both with a varchar(15) column. The first table holds about 300 records, the second about 400.

When i create a merge table from both and do a select i only get null values instead of 700 records.

I've tested it with MySQL 4.1.13, MySQL 5.0.6 and 5.0.9, all from source because i use the SSL support, and on a Linux platform.

With MySQL 5 i even got a "server has gone away" message after the select on the merge table. It sometimes gives 1 record, sometimes a NULL value.

I hope its me coz i'm stuck with this one.

Any ideas ?

Thanks in advance

Arnoud,
Holland