[MDEV-29133] max_recursive_iterations not recognized via configuration file (~/.my.cnf) Created: 2022-07-19  Updated: 2022-07-20  Resolved: 2022-07-20

Status: Closed
Project: MariaDB Server
Component/s: Variables
Affects Version/s: 10.6.8
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Jon Armstrong Assignee: Daniel Black
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Linux


 Description   

Variable "max_recursive_iterations" is not recognized when added to ~/.my.cnf file in [client] or [mysql] sections:

[mysql]
 
max_recursive_iterations = 1050
 
[client]
 
max_recursive_iterations = 1050

When starting the client:

$ mysql
 
mysql: unknown variable 'max_recursive_iterations=1050'

Version of client and server:

Client: mysql  Ver 15.1 Distrib 10.6.8-MariaDB, for Linux (x86_64) using  EditLine wrapper
 
 
 
Server: 10.6.8-MariaDB



 Comments   
Comment by Daniel Black [ 2022-07-20 ]

max_recursive_iterations is a server variable, and isn't an option in the command line options.

In the command line you can SET SESSION max_recursive_iterations=30, or as a command, SET STATEMENT max_recursive_interations=30 FOR SELECT ...

Generated at Thu Feb 08 10:06:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.