SOAR工具给出的explain结果与直接在数据库中执行explain+SQL的结果有差异

[OCod]

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

SELECT
a.table_name,
a.engine,
a.row_format AS format,
a.table_rows,
a.avg_row_length AS avg_row,
round(
(a.data_length + a.index_length) / 1024 / 1024,
2
) AS total_mb,
round(a.data_length / 1024 / 1024, 2) AS data_mb,
round(a.index_length / 1024 / 1024, 2) AS index_mb,
a.create_time,
b.last_update AS last_analyzed
FROM
information_schema.tables a,
mysql.innodb_table_stats b
WHERE
a.table_schema = b.database_name
AND a.table_name = b.table_name
AND a.table_schema = 'mysql'
AND a.table_name = 'user'

SOAR工具给出的explain结果与直接在数据库中执行explain+SQL的结果有差异

2. What did you expect to see?

3. What did you see instead?

4. What version of are you using (soar -version)?

0.11.0

[zhukovaskychina]

有差异很正常，pingcap的实现的物理计划实现和强mysql版本有差异，这个很正常。