[MDEV-19472] eq_range_index_dive_limit cannot be configured in server.cnf Created: 2019-05-14  Updated: 2019-05-17  Resolved: 2019-05-17

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.3.15, 10.2, 10.3, 10.4
Fix Version/s: 10.2.25

Type: Bug Priority: Major
Reporter: Roope Pääkkönen (Inactive) Assignee: Varun Gupta (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Centos 7


 Description   

It seems the recently added variable eq-range-index-dive-limit cannot be configured in server cnf file.
In configuration file I have:

[mariadb]
 
eq_range_index_dive_limit=200

But the server starts up with message:

 
 
localhost.localdomain mysqld[14716]: 2019-05-13 23:02:08 0 [Warning] 'eq-range-index-dive-limit' is MySQL 5.6 / 5.7 compatible option. To be implemented in later versions.

and value is zero in server runtime variables

MariaDB [(none)]> show global variables like 'eq_range_index_dive_limit'\G
 
*************************** 1. row ***************************
 
Variable_name: eq_range_index_dive_limit
 
        Value: 0

But setting it manually seems to work as expected.
Generated at Thu Feb 08 08:51:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.