Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <335767911.1250547074802.JavaMail.jira@brutus>
Date: Mon, 17 Aug 2009 15:11:14 -0700 (PDT)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Assigned: (DERBY-3635) Cannot build SELECT LIST expressions
 involving row_number()
In-Reply-To: <117099521.1208547741570.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ 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.