[
https://issues.apache.org/jira/browse/CALCITE-7835?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu resolved CALCITE-7835.
----------------------------------
Fix Version/s: 1.43.0
Assignee: Mihai Budiu
Resolution: Fixed
Fixed in
[https://github.com/apache/calcite/commit/be78e311dc7194099f26f723fc5347d2e247d3b9]
Thank you for your reviews [~xuzifu666] [~snuyanzin]
> Optimize away LEAD/LAG with a value of 0
> ----------------------------------------
>
> Key: CALCITE-7835
> URL: https://issues.apache.org/jira/browse/CALCITE-7835
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.42.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.43.0
>
>
> A simple rewrite rule could remove LAG/LEAD with a value of 0.
> I also want to note that Calcite allows negative values for LEAD/LAG, which
> the SQL standard rejects, but some dialects allow.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
