Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
N/A
-
None
-
10.1.11
Description
MariaDB [test]> select @@sort_buffer_size; |
+--------------------+ |
| @@sort_buffer_size |
|
+--------------------+ |
| 2097152 |
|
+--------------------+ |
1 row in set (0.00 sec) |
|
|
MariaDB [test]> set statement sort_buffer_size = 100000 for set session sort_buffer_size = 200000; |
Query OK, 0 rows affected (0.00 sec) |
|
|
MariaDB [test]> select @@sort_buffer_size; |
+--------------------+ |
| @@sort_buffer_size |
|
+--------------------+ |
| 2097152 |
|
+--------------------+ |
1 row in set (0.00 sec) |
If it's not expected to work, there should be an error or a warning.
Percona has a more generic flavor of the problem, where it doesn't work for any combination of variables (https://bugs.launchpad.net/percona-server/+bug/1341438), while in our case it happens when the same variable appears in SET STATEMENT and SET SESSION.
