Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.0.12
-
None
-
None
-
Windows and Linux
Description
The variable, aria_used_for_temp_tables, cannot be set via the config (my.cnf, my.ini) file.
This variable is set to ON by default.
mysql> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 10.0.12-MariaDB |
|
+-----------------+
|
|
|
mysql> show global variables like 'aria_used_for_temp_tables';
|
+---------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------+-------+
|
| aria_used_for_temp_tables | ON |
|
+---------------------------+-------+
|
However, if you try to set it explicitly in the config file, you will receive an error:
[mysqld]
|
aria_used_for_temp_tables=ON
|
Note I also tried:
aria_used_for_temp_tables=1
|
aria_used_for_tmp_tables=ON
|
aria_used_for_tmp_tables=1
|
All 4 failed:
140805 15:49:39 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_temp_tables=ON'
|
|
|
140805 15:50:15 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_temp_tables=1'
|
|
|
140805 15:51:20 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_tmp_tables=1'
|
|
|
140805 15:51:39 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_tmp_tables=ON'
|
Note I tried the latter 2 options because of this bug, thinking perhaps that might work:
https://mariadb.atlassian.net/browse/MDEV-4563
I'd suggest if you're going to fix this bug, then I think 4563 should be fixed first, if it is going to be.
Attachments
Issue Links
- relates to
-
MDEV-6630 make aria_used_for_temp_tables a modifiable variable
-
- Open
-