Description:
Query from dump_servers's WHERE clause is incorrect.
https://github.com/mysql/mysql-fabric/blob/release/1.5.6/lib/mysql/fabric/server.py#L838-L...
`status` compares (not equal) with string 'FAULTY' but `status` has integer datatype.
```
mysql> show create table servers\G
*************************** 1. row ***************************
Table: servers
Create Table: CREATE TABLE `servers` (
`server_uuid` varchar(40) NOT NULL,
`server_address` varchar(128) NOT NULL,
`mode` int(11) NOT NULL,
`status` int(11) NOT NULL,
`weight` float NOT NULL,
`group_id` varchar(64) DEFAULT NULL,
PRIMARY KEY (`server_uuid`),
UNIQUE KEY `idx_server_address` (`server_address`),
KEY `idx_group_id` (`group_id`),
CONSTRAINT `fk_group_id_servers` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
```
How to repeat:
```
mysql> SELECT server_uuid, group_id, server_address, mode, status, weight FROM servers WHERE group_id LIKE '%%' AND group_id IS NOT NULL AND status != 'FAULTY' ORDER BY group_id, server_address, server_uuid;
+--------------------------------------+--------------+---------------------+------+--------+--------+
| server_uuid | group_id | server_address | mode | status | weight |
+--------------------------------------+--------------+---------------------+------+--------+--------+
| 8658f0e6-fb9e-11e5-8c6f-001a4a571800 | xxxx_yyyyyyy | 172.19.132.100:3306 | 3 | 3 | 1 |
| fbaeec10-e507-11e5-b2af-001a4a5718ee | zzzzzzzzzz | 172.19.132.110:3306 | 3 | 3 | 1 |
+--------------------------------------+--------------+---------------------+------+--------+--------+
2 rows in set, 1 warning (0.00 sec)
Warning (Code 1292): Truncated incorrect DOUBLE value: 'FAULTY'
```
Suggested fix:
Cast string to integer or `servers`.`status` has to use ENUM datatype.
https://github.com/mysql/mysql-fabric/blob/release/1.5.6/lib/mysql/fabric/server.py#L875-L...