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