Re: [webERP-users] mysql> SET restrict_fk_on_non_standard_key = OFF;

[Tim S. <tim...@gm...>]

This has been discussed here:
https://github.com/timschofield/webERP/issues/351 and it seems mysql
have agreed it is a bug in 8.4 and it will be fixed, but thanks for
the tip about setting

SET restrict_fk_on_non_standard_key = OFF;

Thanks
Tim

On Sun, 23 Feb 2025 at 15:27, adm ti auvix <us...@au...> wrote:
>
> hi!
>
> This url [https://bugs.mysql.com/bug.php?id=114838] show how to disable
>
> There is a seemingly undocumented variable introduced in MySQL 8.4 "RESTRICT_FK_ON_NON_STANDARD_KEY" which is enabled by default.
>
> "Disallow the creation of foreign keys referencing non-unique key"
>
> [7 May 2024 20:04] Evan Elias
>
> Wow, excellent find. Strangely, not only is that new variable undocumented, but it is also deprecated. If you disable it, a warning is issued:
>
> mysql> SET restrict_fk_on_non_standard_key = OFF;
> Query OK, 0 rows affected, 1 warning (0.01 sec)
>
> mysql> SHOW WARNINGS\G
> *************************** 1. row ***************************
>   Level: Warning
>    Code: 4166
> Message: 'restrict_fk_on_non_standard_key' is deprecated and will be removed in a future release. Foreign key referring to non-unique or partial keys is unsafe and may break replication.
> 1 row in set (0.00 sec)
>
>
>
> please in your mysql environment run  SET restrict_fk_on_non_standard_key = OFF;
>
> regards.
>
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users



-- 
www.weberp.org
@TimSchofield2
Blog: https://kwamoja.home.blog/