Bug #38882 Allow sloppy type matches in FOREIGN KEY constraints

Description:
ERROR 1005 (HY000): Can't create table 'miracee.t1' (errno: 150)

$ perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed

This happens when the data type from the reference column is "smaller" as the data type from the foreign key column.

For example integer and bigint or float and double. Every integer should fit into a bigint as well the same with float and double.

Here is no reason to forbid that the foreign key column has data type bigint when the reference column just has integer.

This works fine with char and varchar mixes but not with integer/bigint and float/double. 

How to repeat:
create table t(i integer, primary key(i))engine=innodb;
create table t1(i integer, j bigint, primary key(i), foreign key(j) references t(i))engine=innodb;

You can also try:
create table t2(i float, primary key(i))engine=innodb;
create table t3(i integer, j double, primary key(i), foreign key(j) references t2(i))engine=innodb;

Suggested fix:
...

Any news on it?

Also hits MySQL 8