openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Curtis (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (OPENJPA-2512) QuerySQLCache fails to exclude paginated queries on cache hit
Date Tue, 03 Jun 2014 19:45:02 GMT

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

Mime
View raw message