[SPARK-38655] OffsetWindowFunctionFrameBase cannot find the offset row whose input is not null

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0, 3.2.2
• Component/s: SQL
• Labels: correctness
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 25/Mar/22 09:09
• Updated: 07/Jun/22 02:14
• Resolved: 28/Mar/22 06:18

Description

select x, nth_value(x, 5) IGNORE NULLS over (order by x rows between unbounded preceding and current row)
from (select explode(sequence(1, 3)) x)

returns
null
null
3

But it should returns
null
null
null

Issue Links

• links to: [Github] Pull Request #35971 (beliefer)