Can not set wsrep_desync to ON, OFF, only to TRUE, FALSE
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership | Status tracked in 5.6 | |||||
5.6 |
New
|
Undecided
|
Unassigned |
Bug Description
ON and OFF are not valid values for wsrep_desync , even though they are mentioned in presentations and the Percona documentation.
TRUE and FALSE work.
MySQL [test]> SET GLOBAL wsrep_desync = ON;
ERROR 1396 (HY000): Operation 'desync' failed for SET GLOBAL wsrep_desync = ON
MySQL [test]> SET GLOBAL wsrep_desync = OFF;
Query OK, 0 rows affected, 1 warning (0.01 sec)
MySQL [test]> show warnings;
+------
| Level | Code | Message |
+------
| Warning | 1292 | Truncated incorrect DOUBLE value: 'OFF' |
+------
1 row in set (0.00 sec)