Improve FK constraint error messages was: Foreign key constraint is incorrectly formed on 11.4.2. It works on 10.11.7

[HY000][1005] (conn=6) Can't create table `kasaExample`.`projection` (errno: 150 "Foreign key constraint is incorrectly formed")

constraint fk_projection_project foreign key ( projectId ) references project( id )

unique un_Projection_oneActivePerProject( oneActive ) ignored

drop schema if exists kasaExample;

create schema if not exists kasaExample;

use kasaExample;

create table project(

    id   serial          primary key,

    name text   not null unique     ,

    note text

) with system versioning;

create table projection(

    id        serial          primary key,

    projectId bigint unsigned not null   , constraint fk_projection_project foreign key ( projectId ) references project( id ),

    isActive  boolean         not null     default false comment 'Is this the actively used projection for real world payments and expectations or just a regular test projection?',

    name      varchar( 768 )  not null   ,

    note      text                       ,

    oneActive bigint unsigned as ( if( isActive, projectId, null ) ) invisible,

        unique un_Projection_oneActivePerProject( oneActive ) ignored,

        unique un_projectionName_per_project( projectId, name )

) with system versioning;