mysql strange behaviour

[Bob Bedford]

I've no access to mysql NG, so I ask here.

I've a strange behaviour with mysql.

when I do a select from a simple table, then I get a result for a certain
field
when I then put a "union" and create a query that return no result, I get an
other result for that field. All other fields seems ok.

the field's type are different (one is a mediumint(8) and the other is a
char(13)) it is a problem ?

[Obvious]

On Tue, 30 Aug 2005 11:58:37 +0200, Bob Bedford wrote:

I've no access to mysql NG, so I ask here.

Then subscribe to the MySQL mailing list it's free and details can be found
at the MySQL site.

[Darkstar 3D]

I concur with the Obvious. Also when asking questions like that
anywhere, putting "union" instead of your actual code hampers anyone
from helping. Sometimes when you type out your query to post you see
the error of your ways as well. At least, I do!

[Andy Hassall]

On Tue, 30 Aug 2005 11:58:37 +0200, "Bob Bedford"
<be******@notfo rspammershotmai l.com> wrote:

I've no access to mysql NG
That's because there isn't one yet. But see:
http://www.uvv.org/cgi-bin/getmsg/3750 ... for how to vote if you want one.

In the meantime, there's MySQL mailing lists you can use.
when I do a select from a simple table, then I get a result for a certain
field
when I then put a "union" and create a query that return no result, I get an
other result for that field. All other fields seems ok.

This is all very vague. You'll need to post a runnable example.

--
Andy Hassall :: an**@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool