[Bug] doris自动分析问题

[zhbdesign]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.0.3-rc03

What's Wrong?

创建表后，执行insert进行数据插入，自动分析生效。
执行SHOW AUTO ANALYZE；state为FAILED，message里的内容为：Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Job has been cancelled: Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Job has been cancelled: Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error, Job has been cancelled: Failed to execute internal SQL. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error。
SHOW ANALYZE；show analyze jobid;SHOW ANALYZE TASK STATUS jobid;无法查看自动分析任务的信息
show column stats tablename(id);统计信息已经生成，但是这个sql没数据

What You Expected?

正常执行

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[zhbdesign]

日志里发现一条关于统计信息一直执行的sql，SELECT CONCAT(10061,
'-',
-1,
'-',
'key') AS id,
0 AScatalog_id,
10059 ASdb_id,
10061 AStbl_id,
-1 ASidx_id,
'key' AS col_id,
NULL ASpart_id,
COUNT(1) AS row_count,
NDV(key) AS ndv,
COUNT(1)-COUNT(key) AS null_count,
CAST(MIN(key)ASSTRING) AS min,
CAST(MAX(key)ASSTRING) AS max,
SUM(LENGTH(key)) AS data_size,
NOW() AS update_time
FROM tablename;
key没有加反引号，导致无法执行

[LemonLiTree]

#27321

[Muzi999]

#27321

版本: doris2.1.1
FE警告日志中一直在执行 这样的SQL
SELECT SUBSTRING(CAST(MIN(key) AS STRING), 1, 1024) as min,
SUBSTRING(CAST(MAX(key) AS STRING), 1, 1024) as max
FROM DB.Table index null
然后每次执行都不成功
错误为
Encountered: INDEX
Expected: COMMA, INDEX is keyword, maybe INDEX