[jira] [Created] (SPARK-38655) UnboundedPrecedingOffsetWindowFunctionFrame cannot find the offset row whose input is not null

[jiaan.geng (Jira)]

jiaan.geng created SPARK-38655:
----------------------------------

             Summary: UnboundedPrecedingOffsetWindowFunctionFrame cannot find 
the offset row whose input is not null
                 Key: SPARK-38655
                 URL: https://issues.apache.org/jira/browse/SPARK-38655
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.3.0
            Reporter: jiaan.geng


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



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org