Cannot build SELECT LIST expressions involving row_number()
-----------------------------------------------------------
Key: DERBY-3635
URL: https://issues.apache.org/jira/browse/DERBY-3635
Project: Derby
Issue Type: Bug
Reporter: Rick Hillegas
Priority: Minor
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."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
