[
https://issues.apache.org/jira/browse/FLINK-32367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825031#comment-17825031
]
Jeyhun Karimov commented on FLINK-32367:
----------------------------------------
Hi [~zhou_yb] when I tried to reproduce with the current master
(d6a4eb966fbc47277e07b79e7c64939a62eb1d54), the LEAD function successfully
accepts and executes expression as parameter. For example, the following query
works:
{code:java}
SELECT a, b, lead(b, a/2, 3) over (partition by a order by b), lag(b, 1, 3)
over (partitionby a order by b) FROM Table6{code}
Could you please verify or am I missing sth?
> lead function second param cause ClassCastException
> ---------------------------------------------------
>
> Key: FLINK-32367
> URL: https://issues.apache.org/jira/browse/FLINK-32367
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Affects Versions: 1.15.4
> Reporter: zhou
> Priority: Major
> Attachments: image-2023-06-16-15-49-49-003.png,
> image-2023-06-16-18-12-05-861.png
>
>
> !image-2023-06-16-18-12-05-861.png!!image-2023-06-16-15-49-49-003.png!
> lead function second param is expression (window_length/2),throw a exceptionÂ
> if lead function second param is number,it worked well
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
