Subject Re: [firebird-support] foreign key strangeness
Author Helen Borrie
At 10:57 PM 24/11/2003 +1100, you wrote:
>On Mon, 24 Nov 2003 08:49:59 +0100
>"Daniel Aut" <daniel.aut@...> wrote:
>
> > Hi,
> > I think the columns must be same datatype.
> > id1 -> integer
> > fk2 -> char(5)!!!!
> >
>
>Thanks, Daniel. 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 a bug. I tested it on my RC7 and confirmed it. I forwarded it to
fb-devel for you. :-)

heLen