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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Ubuntu Mono">hi!<br>
      <br>
      This url [<a class="moz-txt-link-freetext" href="https://bugs.mysql.com/bug.php?id=114838">https://bugs.mysql.com/bug.php?id=114838</a>] show how to
      disable <br>
    </font>
    <pre class="note">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"

</pre>
    <div id="c543064" class="comment">
      <div class="header"> [7 May 2024 20:04] Evan Elias </div>
      <pre class="note">Wow, excellent find. Strangely, not only is that new variable undocumented, but it is also deprecated. If you disable it, a warning is issued:

<font size="5">mysql&gt; SET restrict_fk_on_non_standard_key = OFF;</font>
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql&gt; 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.
</pre>
    </div>
  </body>
</html>

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

Accounting & Best Practice Business Administration System

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