Vitalii Li created SPARK-45430:
----------------------------------

             Summary: FramelessOffsetWindowFunctionFrame fails when ignore 
nulls and offset > # of rows 
                 Key: SPARK-45430
                 URL: https://issues.apache.org/jira/browse/SPARK-45430
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.5.0
            Reporter: Vitalii Li


Failure when function that utilized `FramelessOffsetWindowFunctionFrame` is 
used with `ignoreNulls = true` and `offset > rowCount`.

e.g. 

```
select x, lead(x, 5) IGNORE NULLS over (order by x) from (select 
explode(sequence(1, 3)) x)
```



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

Reply via email to