[
https://issues.apache.org/jira/browse/CALCITE-6165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17797912#comment-17797912
]
Caican Cai edited comment on CALCITE-6165 at 12/17/23 11:24 AM:
----------------------------------------------------------------
I can find relevant examples of date_sub and date_add in OperatorTest, but I
did not find the corresponding date function in parserjj.
was (Author: JIRAUSER302115):
I can find relevant examples of date_sub and date_add in OperatorTest, but I
did not find the corresponding date function in parserjj.
/home/ccc/图片/2023-12-17 17-04-29屏幕截图.png !wOf AsM IBROQAAAABJRU5ErkJggg==!
/home/ccc/图片/2023-12-17 17-04-53屏幕截图.png !AaQ7Ebqi103YAAAAAElFTkSuQmCC!
> Add date_sub and date_add functions
> ------------------------------------
>
> Key: CALCITE-6165
> URL: https://issues.apache.org/jira/browse/CALCITE-6165
> Project: Calcite
> Issue Type: Test
> Components: tests
> Affects Versions: 1.36.0
> Reporter: Caican Cai
> Assignee: Caican Cai
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.37.0
>
> Attachments: 2023-12-17 17-04-29屏幕截图.png, 2023-12-17 17-04-53屏幕截图.png
>
>
> In calcite's ParserTest, there is a lack of test for DateFunction. Currently,
> calcite only supports date function from parser.jj:
> date_diff,
> date_trunc.
> It also lacks support for many date functions. For details, you can
> see:[https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html]
> The purpose of adding this datefunctiontest is to tell us which date
> functions are supported and which date functions are not supported
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
