Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 10.3.11
-
Fix Version/s: N/A
-
Component/s: Variables
-
Labels: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)
|
|
|