Skip to content

float RANGE OFFSET and lag/lead_in_frame#21895

Merged
akuzm merged 11 commits intomasterfrom
aku/laglead
Mar 25, 2021
Merged

float RANGE OFFSET and lag/lead_in_frame#21895
akuzm merged 11 commits intomasterfrom
aku/laglead

Conversation

@akuzm
Copy link
Copy Markdown
Contributor

@akuzm akuzm commented Mar 18, 2021

Changelog category (leave one):

  • Improvement

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):
Support RANGE OFFSET frame for floating point types. Implement lagInFrame/leadInFrame window functions, which are analogous to lag/lead, but respect the window frame. They are identical when the frame is between unbounded preceding and unbounded following. This closes #5485.

@robot-clickhouse robot-clickhouse added the pr-improvement Pull request with some product improvements label Mar 18, 2021
@akuzm
Copy link
Copy Markdown
Contributor Author

akuzm commented Mar 23, 2021

Stress test logical error: #22013

@akuzm
Copy link
Copy Markdown
Contributor Author

akuzm commented Mar 25, 2021

Tests OK, now have to rename to lagInFrame because these functions are not standard, and we use camelCase for ClickHouse-specific functions.

@akuzm akuzm merged commit 0675f94 into master Mar 25, 2021
@akuzm akuzm deleted the aku/laglead branch March 25, 2021 20:00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-improvement Pull request with some product improvements

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Accessing previous rows (LAG/LEAD - window function style)

2 participants