Comment 0 for bug 1281696

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

mysql> set global wsrep_desync=ON;
Query OK, 0 rows affected, 2 warnings (0.02 sec)

mysql> show warnings;
+---------+------+----------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'ON' |
| Warning | 1231 | 'wsrep_desync' is already OFF. |
+---------+------+----------------------------------------+
2 rows in set (0.00 sec)

mysql> show global variables like '%desync%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_desync | ON |
+---------------+-------+
1 row in set (0.01 sec)

............
...........

mysql> set global wsrep_desync=OFF;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings
    -> ;
+---------+------+-----------------------------------------+
| Level | Code | Message |
+---------+------+-----------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'OFF' |
+---------+------+-----------------------------------------+
1 row in set (0.00 sec)