Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.11
-
None
Description
Unable to unset a flag from sql_mode set to oracle
MariaDB [(none)]> SET session sql_mode = 'ORACLE';
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [(none)]> SELECT @@SQL_MODE;
|
+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| @@SQL_MODE |
|
+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT |
|
+----------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
|
|
MariaDB [(none)]> SET session sql_mode=(SELECT REPLACE(@@sql_mode,'ANSI_QUOTES',''));
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [(none)]> SELECT @@SQL_MODE;
|
+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| @@SQL_MODE |
|
+----------------------------------------------------------------------------------------------------------------------------------------------+
|
| PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT |
|
+----------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
|
|