# [Know Issue] The same SQL statement query cluster_slow_query and slow_query are inconsistent

## Key Words

TiDB, cluster_slow_query, slow_query, Wrong result, time

## Description

TiDB server 查询 cluster_slow_query 表和 slow_query 表的数据时发现两张表的数据不能匹配上，query 和结果示例：

```sql
mysql> select digest,count,substr(query,1,20) from information_schema.cluster_slow_query where time >='2022-11-06 16:00:00' and time <= '2022-11-06 16:10:00' and is_internal=0 and query not like 'analyze%' and query not like '%ALTER%%' group by digest order by avg(query_time)desc limit 10;
----------------------------------------------------------------------------------------------
 
digest  count   substr(query,1,20)
----------------------------------------------------------------------------------------------
 
fa95ace48c80cad19b5c33537c1eed64706bef7f6420d1dae022a6e4a1544af8    1   select count from
f073ed327814dfaba22331aa1b6a953c3924ed9c8543860c007aca7e70696547    3   select count from
0cab60e7438a5754175ba9d4a22654be5d0ba8418cff0cf0dea2790083d63b90    2   select time,query_ti
33508ba1b5a199d53785b197a135d82a1c4a27f86f91596a293a929f46e7f3f4    1   select instance,time
0c61b06594121c8896d05a1cd585f837a58b7747d7abdc5cb90bb5fd76846f1e    2   select time,query_ti
ba41386a7e4bc73a26c69c620960e42acda22e0f7bc3f3c6fb9eb71ec7b9583f    45  INSERT INTO sbtest1
----------------------------------------------------------------------------------------------
6 rows in set (1.52 sec)
 
mysql> select digest,count,substr(query,1,20) from information_schema.slow_query where time >='2022-11-06 16:00:00' and time <= '2022-11-06 16:10:00' and is_internal=0 and query not like 'analyze%' and query not like '%ALTER%%' group by digest order by avg(query_time)desc limit 10;
----------------------------------------------------------------------------------------------
 
digest  count   substr(query,1,20)
----------------------------------------------------------------------------------------------
 
ba41386a7e4bc73a26c69c620960e42acda22e0f7bc3f3c6fb9eb71ec7b9583f    249625  INSERT INTO sbtest1
----------------------------------------------------------------------------------------------
1 row in set (7.78 sec)
```

## Root Cause

当查询 slow_query table 时，当 MemTable 的输出列不包含 'time' 列时，它不会解码 'time' 列，从而忽略 'time' 过滤条件， 就会造成 slow_query table 输出结果不对的问题。

## Diagnostic Steps

N/A

## Resolution

升级到未受影响版本:

v5.2.5 ~

v5.3.1 ~

v5.4.3 ~

v6.1.0 ~

## Workaround

N/A

## Affected Versions

v5.2.0 ~ v5.2.4

v5.3.0 ~ v5.3.1

v5.4.0 ~ v5.4.2

v6.0.0