bug: UDAF can not be used as window function

[wangrunji0408]

Describe the bug

No response

Error message/log

Invalid input syntax: column must appear in the GROUP BY clause or be used in an aggregate function

To Reproduce

create aggregate sum00(value int) returns int language python as $$
def create_state():
    return 0
def accumulate(state, value):
    return state + value
def retract(state, value):
    return state - value
def finish(state):
    return state
$$;

select t.value, sum00(weight) OVER (PARTITION BY value) from (values (1, 1), (null, 2), (3, 3)) as t(value, weight);

Expected behavior

I expect to see the output:

 value | weighted_avg 
-------+--------------
     1 |            1
     3 |            3
(2 rows)

However, it returned this error:

ERROR:  Failed to run the query

Caused by:
  Invalid input syntax: column must appear in the GROUP BY clause or be used in an aggregate function

How did you deploy RisingWave?

./risedev p

The version of RisingWave

latest main branch

Additional context

No response