Bug in nth_value() window function for NULL input (SQLancer)

[2010YOUY01]

Describe the bug

There are two unexcepted behavior in nth_value() window function

1. When NULL literal is used in the second arg, it returned Execution error: Expected an integer value
   The expected behavior is to evaluate all rows to NULL, because NULL should be treated as a missing integer value

2. When second arg is col*NULL, it returned another unexpected internal error

More details can be found in the reproducer in datafusion-cli (Compiled from latest main, commit hash 6bbad7e, with cargo run)

DataFusion CLI v41.0.0
> create table t1(v1 int, v2 int);
insert into t1 values (1,1), (1,2),(1,3),(2,1),(2,2);

> select v1, nth_value(v2, null) over (partition by v1 order by v2) from t1;

Execution error: Expected an integer value

> select v1, nth_value(v2, v2*null) over (partition by v1 order by v2) from t1;
Internal error: Cannot convert Int64(NULL) to i64.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker

Expected behavior in DuckDB (output in postgres is the same)

D select v1, nth_value(v2, null) over (partition by v1 order by v2) from t1;
┌───────┬────────────────────────────────────────────────────────┐
│  v1   │ nth_value(v2, NULL) OVER (PARTITION BY v1 ORDER BY v2) │
│ int32 │                         int32                          │
├───────┼────────────────────────────────────────────────────────┤
│     2 │                                                        │
│     2 │                                                        │
│     1 │                                                        │
│     1 │                                                        │
│     1 │                                                        │
└───────┴────────────────────────────────────────────────────────┘

D select v1, nth_value(v2, v2*null) over (partition by v1 order by v2) from t1;
┌───────┬───────────────────────────────────────────────────────────────┐
│  v1   │ nth_value(v2, (v2 * NULL)) OVER (PARTITION BY v1 ORDER BY v2) │
│ int32 │                             int32                             │
├───────┼───────────────────────────────────────────────────────────────┤
│     2 │                                                               │
│     2 │                                                               │
│     1 │                                                               │
│     1 │                                                               │
│     1 │                                                               │
└───────┴───────────────────────────────────────────────────────────────┘

To Reproduce

No response

Expected behavior

No response

Additional context

Found by SQLancer #11030

[thinh2]

take

[dharanad]

take