db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3635) Cannot build SELECT LIST expressions involving row_number()
Date Fri, 18 Apr 2008 19:42:21 GMT
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.


Mime
View raw message