[Bug] doris自动分析问题

[zhbdesign]

Search before asking

• [X] 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

• [X] 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]

https://github.com/apache/doris/pull/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