[
https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik reassigned DERBY-3635:
------------------------------------
Assignee: Dag H. Wanvik
> 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
> Components: SQL
> Reporter: Rick Hillegas
> Assignee: Dag H. Wanvik
> 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.
