Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
The variable sql_select_limit cannot be set as Global via config file.
Customer reports that attempt to set sql_select_limit=N in any section of .cnf other than [client] fails with the error
...
[ERROR] /usr/sbin/mysqld: unknown variable 'sql_select_limit=10'
...
If the variable placed in .cnf [client] section, its local. It still can be set as global via client as
MariaDB [(none)]> set global sql_select_limit=100;
Query OK, 0 rows affected (0.000 sec)
but the customer feels that the behavior is an omission, since it contradicts with Doc
https://mariadb.com/kb/en/server-system-variables/#sql_select_limit
and would like the fix.