SQLite version 3.34.1 2021-01-20 14:10:07

Hi,

I'm trying to use window function row_number(), when I put a constant integer with ORDER BY, found some weird things.
Here are test runs:

CREATE TABLE tbl (id INTEGER PRIMARY KEY);
INSERT INTO tbl VALUES(1),(2);


SELECT id,row_number() OVER (ORDER BY "id" DESC) FROM tbl ORDER BY 1;

expected and real output:
1|2
2|1


SELECT id,row_number() OVER (ORDER BY 1 DESC) FROM tbl ORDER BY 1;

expected output:
1|2
2|1

real output:
1|1
2|2


SELECT id,row_number() OVER (ORDER BY 0) FROM tbl ORDER BY 1;

expected:
Prompt error: ORDER BY term out of range - should be between 1 and 2

real output:
1|1
2|2

SELECT id,row_number() OVER (ORDER BY 1000) FROM tbl ORDER BY 1;

expected:
Prompt error: ORDER BY term out of range - should be between 1 and 2

real output:
1|1
2|2

So is there anything regarding special ORDER BY clause processing in the doc that I missed, so could it be a bug?

Much thanks!