Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support parsing Snowflake style DATEADD() function with date part as string literal #11938

Closed
lukaseder opened this issue Jun 1, 2021 · 3 comments
Closed

Support parsing Snowflake style DATEADD() function with date part as string literal #11938

lukaseder opened this issue Jun 1, 2021 · 3 comments
Labels
C: Parser E: All Editions P: Medium R: Fixed T: Enhancement
Projects
3.15 Other improvements
Milestone
Version 3.15.0

Comments

@lukaseder
Copy link
Member

This is valid Snowflake SQL:

-- With a string literal
select dateadd('month', 1, date '2000-01-01')

-- With a date part
select dateadd(month, 1, date '2000-01-01')

We currently only support the date part version.
@lukaseder lukaseder added this to the Version 3.15.0 milestone Jun 1, 2021
@lukaseder lukaseder added this to To do in 3.15 Other improvements via automation Jun 1, 2021
@lukaseder
Copy link
Member Author

See also: #11931

@lukaseder
Copy link
Member Author

It seems that all date parts can be used as string literals in Snowflake, e.g. also:

select extract('month' from date '2000-01-01')

lukaseder added a commit that referenced this issue Jun 1, 2021
@lukaseder
[#11938] Support parsing Snowflake style DATEADD() function
61a827c 
with date part as string literal
@lukaseder
Copy link
Member Author

Fixed for jOOQ 3.15.0

3.15 Other improvements automation moved this from To do to Done Jun 1, 2021
@lukaseder lukaseder mentioned this issue Jun 1, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C: Parser E: All Editions P: Medium R: Fixed T: Enhancement
Projects
No open projects
3.15 Other improvements
  
Done
Milestone
Version 3.15.0
Development

No branches or pull requests
1 participant
@lukaseder