Subject | Re: [firebird-support] foreign key strangeness |
---|---|
Author | Martijn Tonies |
Post date | 2003-11-24T12:52:06Z |
Hi,
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
> > Thanks, Daniel. My point was that the engine accepted themOut of curiosity: exactly what part is the issue? And what part
> > 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.
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