You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Catalina Wei (JIRA)" <ji...@apache.org> on 2007/09/20 21:08:31 UTC
[jira] Created: (OPENJPA-378) DB2 SQL incorrectly generating "FETCH
FIRST n ROWS ONLY" in subselects
DB2 SQL incorrectly generating "FETCH FIRST n ROWS ONLY" in subselects
----------------------------------------------------------------------
Key: OPENJPA-378
URL: https://issues.apache.org/jira/browse/OPENJPA-378
Project: OpenJPA
Issue Type: Bug
Components: sql
Affects Versions: 1.0.0, 1.0.1, 1.1.0
Reporter: Catalina Wei
Assignee: Catalina Wei
Fix For: 1.0.1, 1.1.0
For select count(*) from (subselect), "FETCH FIRST n ROWS ONLY" clause was generated which is INVALID syntax in DB2.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (OPENJPA-378) DB2 SQL incorrectly generating
"FETCH FIRST n ROWS ONLY" in subselects
Posted by "Catalina Wei (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Catalina Wei resolved OPENJPA-378.
----------------------------------
Resolution: Fixed
fixed in 1.0.x branch, revision r577972, trunk revision r577973.
> DB2 SQL incorrectly generating "FETCH FIRST n ROWS ONLY" in subselects
> ----------------------------------------------------------------------
>
> Key: OPENJPA-378
> URL: https://issues.apache.org/jira/browse/OPENJPA-378
> Project: OpenJPA
> Issue Type: Bug
> Components: sql
> Affects Versions: 1.0.0, 1.0.1, 1.1.0
> Reporter: Catalina Wei
> Assignee: Catalina Wei
> Fix For: 1.0.1, 1.1.0
>
>
> For select count(*) from (subselect), "FETCH FIRST n ROWS ONLY" clause was generated which is INVALID syntax in DB2.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.