[Bug] show create table 出来的语句执行异常

[lizhian]

Search before asking

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

Version

Caused by: java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 9:
AUTO PARTITION BY RANGE date_trunc(k1, 'year')
^
Encountered: IDENTIFIER
Expected

原因:
实际建表语句是: AUTO PARTITION BY RANGE (date_trunc(k1, 'year'))
show create table语句是: AUTO PARTITION BY RANGE date_trunc(k1, 'year')

少了一个(),导致执行错误

What's Wrong?

Caused by: java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 9:
AUTO PARTITION BY RANGE date_trunc(k1, 'year')
^
Encountered: IDENTIFIER
Expected

What You Expected?

实际建表语句是: AUTO PARTITION BY RANGE (date_trunc(k1, 'year'))
show create table语句是: AUTO PARTITION BY RANGE date_trunc(k1, 'year')

少了一个(),导致执行错误

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

[wyxxxcat]

你好，能提供下你的 doris 版本吗

[wyxxxcat]

#34071 这个 pr 修复了相关的问题，可以看看你的版本是否包含这个修复

[lizhian]

Git : git://qa-regression-nodes-agent@64651a9

Version : doris-3.0.7-rc01

BuildInfo : qa-regression-nodes-agent

BuildTime : Tue, 12 Aug 2025 13:58:20 3Z 使用的是这个版本,没有修复

[wyxxxcat]

Git : git://qa-regression-nodes-agent@64651a9

Version : doris-3.0.7-rc01

BuildInfo : qa-regression-nodes-agent

BuildTime : Tue, 12 Aug 2025 13:58:20 3Z 使用的是这个版本,没有修复

https://github.com/apache/doris/commits/3.0.7-rc01/fe/fe-core/src/main/java/org/apache/doris/catalog/RangePartitionInfo.java
这里是有修复的 pr 的