【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】v7.1.3/v7.5.4
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
MySQL [INFORMATION_SCHEMA]> select count() from INFORMATION_SCHEMA.CLUSTER_SLOW_QUERY WHERE time >= “2000-11-07 09:05:00.755514”;
±---------+
| count() |
±---------+
| 0 |
±---------+
1 row in set (0.00 sec)
MySQL [INFORMATION_SCHEMA]> select count() from INFORMATION_SCHEMA.CLUSTER_SLOW_QUERY;
±---------+
| count() |
±---------+
| 2139 |
±---------+
1 row in set (0.38 sec)
MySQL [INFORMATION_SCHEMA]> select min(time) from INFORMATION_SCHEMA.CLUSTER_SLOW_QUERY;
±---------------------------+
| min(time) |
±---------------------------+
| 2025-02-07 12:46:11.801819 |
±---------------------------+
1 row in set (0.17 sec)
MySQL [INFORMATION_SCHEMA]> select count() from INFORMATION_SCHEMA.CLUSTER_SLOW_QUERY WHERE time >= ‘2025-02-07 12:46:11.801819’;
±---------+
| count() |
±---------+
| 596 |
±---------+
1 row in set (0.49 sec)
| Time | timestamp(6) | NO | PRI | NULL | |
timestamp类型可以直接这样比较大小吗?为什么条件是min,查出来的结果不是全部值?