You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "lizhian (via GitHub)" <gi...@apache.org> on 2025/10/01 02:36:36 UTC
[I] [Bug] show create table 出来的语句执行异常 [doris]
lizhian opened a new issue, #56697:
URL: https://github.com/apache/doris/issues/56697
### Search before asking
- [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) 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
- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] show create table 出来的语句执行异常 [doris]
Posted by "lizhian (via GitHub)" <gi...@apache.org>.
lizhian commented on issue #56697:
URL: https://github.com/apache/doris/issues/56697#issuecomment-3405264083
Git : git://qa-regression-nodes-agent@64651a9f2e98b0faddc45a78b2165007d5e3ba5a
Version : doris-3.0.7-rc01
BuildInfo : qa-regression-nodes-agent
BuildTime : Tue, 12 Aug 2025 13:58:20 3Z 使用的是这个版本,没有修复
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] show create table 出来的语句执行异常 [doris]
Posted by "wyxxxcat (via GitHub)" <gi...@apache.org>.
wyxxxcat commented on issue #56697:
URL: https://github.com/apache/doris/issues/56697#issuecomment-3404342480
https://github.com/apache/doris/pull/34071 这个 pr 修复了相关的问题，可以看看你的版本是否包含这个修复
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] show create table 出来的语句执行异常 [doris]
Posted by "wyxxxcat (via GitHub)" <gi...@apache.org>.
wyxxxcat commented on issue #56697:
URL: https://github.com/apache/doris/issues/56697#issuecomment-3405853447
> Git : git://qa-regression-nodes-agent@[64651a9](https://github.com/apache/doris/commit/64651a9f2e98b0faddc45a78b2165007d5e3ba5a)
>
> 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 的
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] show create table 出来的语句执行异常 [doris]
Posted by "wyxxxcat (via GitHub)" <gi...@apache.org>.
wyxxxcat commented on issue #56697:
URL: https://github.com/apache/doris/issues/56697#issuecomment-3404330413
你好，能提供下你的 doris 版本吗
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] show create table 出来的语句执行异常 [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #56697: [Bug] show create table 出来的语句执行异常
URL: https://github.com/apache/doris/issues/56697
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] show create table 出来的语句执行异常 [doris]
Posted by "lizhian (via GitHub)" <gi...@apache.org>.
lizhian commented on issue #56697:
URL: https://github.com/apache/doris/issues/56697#issuecomment-3405262969
Git : git://qa-regression-nodes-agent@64651a9f2e98b0faddc45a78b2165007d5e3ba5a
Version : doris-3.0.7-rc01
BuildInfo : qa-regression-nodes-agent
BuildTime : Tue, 12 Aug 2025 13:58:20 3Z
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] show create table 出来的语句执行异常 [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #56697:
URL: https://github.com/apache/doris/issues/56697#issuecomment-4240467314
We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org