You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2008/04/18 21:42:21 UTC
[jira] Created: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
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.
[jira] Updated: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Thomas Nielsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Nielsen updated DERBY-3635:
----------------------------------
Component/s: SQL
> 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
> 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.
[jira] Closed: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-3635.
--------------------------------
> 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
> Fix For: 10.6.1.0
>
>
> 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.
[jira] Updated: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-3635:
---------------------------------
Issue & fix info: [Patch Available]
> 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.
[jira] Resolved: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik resolved DERBY-3635.
----------------------------------
Resolution: Fixed
Fix Version/s: 10.6.0.0
Issue & fix info: (was: [Patch Available])
DERBY-4413 has been resolved with a fix that fixes this issue as well, so resolving.
> 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
> Fix For: 10.6.0.0
>
>
> 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.
[jira] Updated: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-3635:
--------------------------------------
Urgency: Normal
Assignee: (was: Dag H. Wanvik)
Triaged for 10.5.2. Unassigning since there has been no activity.
> 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
> 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.
[jira] Commented: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12746937#action_12746937 ]
Dag H. Wanvik commented on DERBY-3635:
--------------------------------------
There is a patch under DERBY-3634 that fixes this issue as well; marking "patch available".
> 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.
[jira] Assigned: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Assigned: (DERBY-3635) Cannot build SELECT LIST expressions
involving row_number()
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ 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.