Re: Windowing Function Patch Review -> ROW_NUMBER without ORDER BY

Hitoshi Harada wrote:
> > The spec says: "The ROW_NUMBER function computes the sequential row
> number,
> > starting with 1 (one) for the first row, of the row within its window
> > partition according to the window ordering of the window."
> >
> > I'm just not sure if we should block this or not.
> >
> > Does anyone see this as a feature?
>
> I don't see any reason to take it as a bug. It may be confusing some
> people but it is consistent enough and not ambiguous. Many users
> already know if they don't specify ORDER BY clause in a simple regular
> query they wouldn't receive ordered rows so it will match their
> senses.

"Bug" was probably the wrong word for me to use. At the time I was thinking
it could easily be misused. The last sentence in the above quote seemed to
change my mind about this. Perhaps it is slightly unusual but it may come in
useful for someone.

David.