Subject Re: [firebird-support] foreign key strangeness
Author Martijn Tonies
Hi,

> > 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 was by design,
> > or an issue?
>
> Both ;-) And I tend to fix this in the next FB release.

Out of curiosity: exactly what part is the issue? And what part
is by design? :)

Meaning: can't I create an FK from an Integer to a VARCHAR
containing integers?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com