Minor Description
The row_number() windowing function does not behave like other expressions which appear in the SELECT LIST. With other SELECT LIST expressions, you can build up more complicated expressions. If we decide not to lift this limitation, we should probably at least mention it in the ROW_NUMBER section of the Derby Reference Manual.
The following query works:
select a + 1 as c, row_number() over () as row_number
from t
where a > 100 and a < 111
;
The following query raises an error:
select a, (row_number() over ()) + 1 as row_number
from t
where a > 100 and a < 111
This is the error I see: "ERROR 42X01: Syntax error: Encountered "over" at line 2, column 25."
Attachments
Issue Links
- relates to
-
DERBY-3634 Cannot use row_number() in ORDER BY clause
-
- Closed
-