> In my understanding to determine whether a
> row is in frame, we need to fetch the row first. We need to check the
> tuple content in some frame options.
I agree about nth_value() with RESPECT NULLS. It has always worked
this way.
But for ROWS frames row_is_in_frame() can tell from the position
alone that the row is out of frame. The attached patch moves that call
back in front of the partition end check. Fujii-san's query returns
NULL again, and the loop from the original report still ends.
Thanks,
Shihao