select on varchar
Posted by:
Arnoud
Date: July 21, 2005 03:22PM
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
Subject
Views
Written By
Posted
select on varchar
9740
July 21, 2005 03:22PM
4568
July 22, 2005 01:42AM
6755
July 24, 2005 03:37AM
4676
July 24, 2005 06:30PM
4199
August 09, 2005 03:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.