[MDEV-13099] Variable wsrep_slave_fk_checks actually is wsrep_slave_FK_checks Created: 2017-06-15  Updated: 2017-07-05  Resolved: 2017-07-05

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Galera
Affects Version/s: 10.2.6
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Anders Karlsson Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux CentOS 6.4



 Description   

The variable wsrep_slave_fk_check as documented here: https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_slave_fk_checks is actually called wsrep_slave_FK_checks. It is odd that this is the only variable, at least that I can think of, that is upper case. This took me quite a while to figure out.



 Comments   
Comment by Ian Gilfillan [ 2017-06-15 ]

In what context did you discover the case is important? The same applies to wsrep_slave_UK_checks.

Comment by Anders Karlsson [ 2017-06-20 ]

To answer your question:
I found that it is important as if I set it to wsrep_slave_fk_checks in lower case, the server will not start.

I did see it in SHOW VARIABLES where it is shown as wsrep_slave_fk_checks:

MariaDB [test]> show variables like '%fk%';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| wsrep_slave_fk_checks | OFF   |
+-----------------------+-------+
1 row in set (0.00 sec)

But when I set it it has to be called wsrep_slave_FK_checks. So this is also a software issue, as well as a documentation issue.

Comment by Ian Gilfillan [ 2017-07-05 ]

Docs have been updated

Generated at Thu Feb 08 08:02:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.