[
https://issues.apache.org/jira/browse/OPENJPA-2512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Curtis updated OPENJPA-2512:
---------------------------------
Attachment: OPENJPA-2512.20x.ut.patch
> QuerySQLCache fails to exclude paginated queries on cache hit
> -------------------------------------------------------------
>
> Key: OPENJPA-2512
> URL: https://issues.apache.org/jira/browse/OPENJPA-2512
> Project: OpenJPA
> Issue Type: Bug
> Components: query
> Affects Versions: 2.0.2
> Reporter: Rick Curtis
> Labels: querysqlcache
> Attachments: OPENJPA-2512.20x.ut.patch
>
>
> While testing another issue, I encountered a bug with the QuerySQLCache. If
> you execute JPQL that has query pagination, we recognize that and exclude the
> query from the cache[1]. If you execute the query once without pagination,
> then execute it again with pagination we will 'forget' about the pagination
> and return the entire result set. I'll attach a JUnit showing the issue.
> [1] 1864 test WARN [main] openjpa.Runtime - Query "select e from simple e
> WHERE e.name=:name order by e.value" is removed from cache excluded
> permanently. The following query is not cached because the query uses
> pagination: select e from simple e WHERE e.name=:name order by e.value.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
