my english is bad, so…
i found a bug about qan, seems like the query is wrong
see pic
enter docker, login to mysql (by the way, why use mysql5.5?), run the sql
mysql> SELECT name FROM pmm.instances WHERE subsystem_id IN (3, 4) AND (deleted IS NULL OR deleted = ‘1970-01-01 00:00:01’);
Empty set (0.00 sec)
now, where 1=1
mysql> SELECT name,subsystem_id,deleted FROM pmm.instances ;
±-------------------±-------------±--------------------+
| name | subsystem_id | deleted |
±-------------------±-------------±--------------------+
| 192.168.1.169_3306 | 3 | 1970-01-01 08:00:01 |
| 192.168.1.171_3306 | 3 | 1970-01-01 08:00:01 |
| 192.168.1.191_3306 | 3 | 1970-01-01 08:00:01 |
deleted = 1970-01-01 08:00:01 but where ‘1970-01-01 00:00:01’
