8.0.25 vs 8.0.26 : SET SESSION innodb_strict_mode = OFF

8025.txt

mysql> SELECT @@version;
+-----------+
| @@version |
+-----------+
| 8.0.25    |
+-----------+
1 row in set (0.00 sec)

mysql> SHOW GRANTS;
+--------------------------------------+
| Grants for yoku0825@%                |
+--------------------------------------+
| GRANT USAGE ON *.* TO `yoku0825`@`%` |
+--------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT @@session.innodb_strict_mode;
+------------------------------+
| @@session.innodb_strict_mode |
+------------------------------+
|                            1 |
+------------------------------+
1 row in set (0.00 sec)

mysql> SET SESSION innodb_strict_mode = OFF;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @@session.innodb_strict_mode;
+------------------------------+
| @@session.innodb_strict_mode |
+------------------------------+
|                            0 |
+------------------------------+
1 row in set (0.00 sec)

8026.txt

mysql80 11> SELECT @@version;
+-----------+
| @@version |
+-----------+
| 8.0.26    |
+-----------+
1 row in set (0.00 sec)

mysql80 11> SHOW GRANTS;
+--------------------------------------+
| Grants for yoku0825@%                |
+--------------------------------------+
| GRANT USAGE ON *.* TO `yoku0825`@`%` |
+--------------------------------------+
1 row in set (0.01 sec)

mysql80 11> SELECT @@session.innodb_strict_mode;
+------------------------------+
| @@session.innodb_strict_mode |
+------------------------------+
|                            1 |
+------------------------------+
1 row in set (0.00 sec)

mysql80 11> SET SESSION innodb_strict_mode = OFF;
ERROR 1227 (42000): Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation