[
https://issues.apache.org/jira/browse/CALCITE-7096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18007378#comment-18007378
]
Yu Xu commented on CALCITE-7096:
--------------------------------
All test case had been test ok in StarRocks.
> Invalid unparse for EXTRACT in StarRocks
> ----------------------------------------
>
> Key: CALCITE-7096
> URL: https://issues.apache.org/jira/browse/CALCITE-7096
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.40.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.41.0
>
>
> starrocks sql:
> {code:java}
> select EXTRACT(HOUR FROM DATETIME '2023-12-01 00:00:00') {code}
> {code:java}
> com.starrocks.common.AnalysisException: Getting syntax error. Detail message:
> Parse Error : unknown type DATETIME.
> at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:477)
> ~[starrocks-fe.jar:?]
> at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:778)
> ~[starrocks-fe.jar:?]
> at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:1072)
> ~[starrocks-fe.jar:?]
> at
> com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69)
> ~[starrocks-fe.jar:?]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
> ~[?:?]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
> ~[?:?]
> at java.lang.Thread.run(Thread.java:833) ~[?:?]
> {code}
>
> not need any time unit such as date/datetime/timestamp
> {code:java}
> select EXTRACT(HOUR FROM '2023-12-01 12:00:00'){code}
> result is ok:
> {code:java}
> 12
> {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
