On Mon, 24 Nov 2003 08:49:59 +0100

>Andrew Gough wrote:
>
>My point was that the engine accepted them when they *were* different. Obviously, they *should* be the same but it seems that it is a legal (ie. no errors are reported) construction to have them unmatched.
>
>This seems odd to me, and I was wondering if it ws by design, or an issue?
>

It's legal and works fine. You can compare a string to a number - you
do it all the time with literals - and the database provides
conversions. The difference in datatypes may indicate an error in the
logic of picking foreign keys, but that's really not the database's
decision.

Regards,


Ann