Subject Re: [firebird-support] Foreign key different field type
Author Svein Erling Tysvær
Well, I would hope that

create procedure ...
declare variable i2 TYPE OF COLUMN test2.id1;
declare variable i TYPE OF COLUMN;
  i2 = 12345678;
  i = 12345678;

would complain about the assignment to i and not i2.

Although I agree with you that it sounds rather useless to allow foreign keys to be of a type that is a superset, it also sounds rather harmless (if properly implemented). Does the SQL standard say anything about this?