-
Notifications
You must be signed in to change notification settings - Fork 2.5k
Issue #600: Improve DATEXXX #2095
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.
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
Conversation
Now that there are structs for all temporal types, we can dispense with the separate structs and lose some duplicated code.
Special case constant date part strings.
Special case constant part string. Refactor to look like the other part functions.
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
Thanks for the PR! Looks great. Some comments:
Remove constant optimisation in DATEPART because the translator handles it. Tweak Quater extraction to use Date::Convert.
I expect removing the constant optimisation should implode the coverage statistics... |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
Thanks, looks great now! Two more minor coverage requests, then I think it's ready to go:
Add missing DATE_TRUNC constant tests. Fix DATE_TRUNC ms/µs confusion. Add missing YEARWEEK date part and tests.
Thanks, looks great! |
Disallow streaming window execution for DISTINCT aggregates. fixes: duckdblabs/duckdb-internal#2095
Internal #2095: Streaming Window Structs
Disallow streaming window execution for DISTINCT aggregates. fixes: duckdblabs/duckdb-internal#2095
Clean up the code and add special cases for the common situation where the part is a constant string.