Buy Percona ServicesBuy Now!

1.13.0 qan bug

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 1.13.0 qan bug

    my english is bad, so..
    i found a bug about qan, seems like the query is wrong
    see pic
    Click image for larger version

Name:	
Views:	1
Size:	668.1 KB
ID:	51994

    Click image for larger version

Name:	
Views:	1
Size:	579.7 KB
ID:	51995Click image for larger version

Name:	
Views:	1
Size:	91.6 KB
ID:	51996Click image for larger version

Name:	
Views:	1
Size:	121.0 KB
ID:	51997
    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'

    Last edited by Fan; 08-04-2018, 12:18 AM. Reason: pic
Working...
X