HIGH_NOT_PRECEDENCE
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Modes for MariaDB Xpand
Topics on this page:
Overview
This SQL mode is accepted without error, but it has no effect on DB behavior and it is discarded from the SQL mode string.
EXAMPLES
Setting the SQL_MODE
Note that @@sql_mode
is the same as @@session.sql_mode
:
SELECT @@sql_mode, @@session.sql_mode;
+---------------------+---------------------+
| @@sql_mode | @@session.sql_mode |
+---------------------+---------------------+
| STRICT_TRANS_TABLES | STRICT_TRANS_TABLES |
+---------------------+---------------------+
The ignored HIGH_NOT_PRECEDENCE
value is accepted without error, but discarded from the SQL_MODE
value:
SET sql_mode = CONCAT(@@sql_mode, ',HIGH_NOT_PRECEDENCE');
SELECT @@sql_mode;
+---------------------+
| @@sql_mode |
+---------------------+
| STRICT_TRANS_TABLES |
+---------------------+
Assigning an empty string turns off all SQL_MODE
flags:
SET sql_mode = '';