Not the answer you need?
Register and ask your own question!

1.13.0 qan bug

FanFan ContributorCurrent User Role Patron
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'
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.