query information_schema.metrics_summary table failed

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. tiup playground nightly
2. execute sql

select count(1) from information_schema.metrics_summary

2. What did you expect to see? (Required)

execute success.

3. What did you see instead (Required)

MySQL root@127.0.0.1:(none)> select count(1) from information_schema.metrics_summary;
(1105, "execute 'select sum(value),avg(value),min(value),max(value) from `metrics_schema`.`tidb_distsql_copr_cache` where time>='2022-06-30 16:09:10.063' and time<='2022-06-30 16:39:10.063'' failed: query metric error, msg: 1:62: parse error: unexpected right parenthesis ')', detail: ")

4. What is your TiDB version? (Required)

tidb_version() | Release Version: v6.2.0-alpha
Edition: Community
Git Commit Hash: ed5e63a7a0a275e313cd78ab1777e46803c2de53
Git Branch: heads/refs/tags/v6.2.0-alpha
UTC Build Time: 2022-06-28 14:25:45
GoVersion: go1.18.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
Store: tikv