[
https://issues.apache.org/jira/browse/OPENJPA-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mark Struberg resolved OPENJPA-2771.
------------------------------------
Resolution: Fixed
> It seems like h2 'unlimited' is not "LIMIT 0" but rather "LIMIT -1"
> -------------------------------------------------------------------
>
> Key: OPENJPA-2771
> URL: https://issues.apache.org/jira/browse/OPENJPA-2771
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 3.0.0
> Reporter: Mark Struberg
> Assignee: Mark Struberg
> Priority: Major
> Fix For: 3.0.1
>
>
> Our H2Dictionary currently sets {{LIMIT 0 OFFSET 3}} when a
> {{Query#setFirstResult(3)}} is set without any {{setMaxResults}}.
> This results in zero entries in the result list.
> When I set {{LIMIT -1}, then all works fine.
> According to the h2database documentation at
> http://h2database.com/html/grammar.html we can assume the followint:
> {quote}LIMIT and FETCH FIRST/NEXT ROW(S) ONLY limits the number of rows
> returned by the query (no limit if null or smaller than zero). OFFSET
> specified how many rows to skip{quote}
> If I read this correctly then we can skip the whole LIMIT clause if no
> {{setMaxResults}} was set.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
