# 1.13.0 qan bug

**URL:** https://forums.percona.com/t/1-13-0-qan-bug/6492
**Category:** PMM 1.x
**Created:** [August 3, 2018, 11:46pm UTC](https://forums.percona.com/t/1-13-0-qan-bug/6492 "2018-08-03T23:46:25Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Fan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fan/32/40_2.png) [@Fan](https://forums.percona.com/u/Fan)
#### Post date: [August 3, 2018, 11:46pm UTC](https://forums.percona.com/t/1-13-0-qan-bug/6492/1 "2018-08-03T23:46:25Z")

</div>

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’

 ![photoid=51994](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/8/8e49f4c0efec561e48b9d10ddadf2bf65e05ff1b.jpeg)

 ![photoid=51995](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/236e99221dc96dfddf3f1d68197f430ba7889661.jpeg)

 ![photoid=51996](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/0237fd2394ab97f330c55707c17c89ad9e24116e.png)

 ![photoid=51997](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/0a992f935f2051d2a70869d1baad0536d8be71d0.png)