[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6979) QueryPlanCache is not used in an optimal way

[Jan Stolze (JIRA)]

QueryPlanCache is not used in an optimal way
--------------------------------------------

                 Key: HHH-6979
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6979
             Project: Hibernate ORM
          Issue Type: Bug
    Affects Versions: 3.6.1
            Reporter: Jan Stolze
            Priority: Critical
         Attachments: FlushAndTransactionTest.java

The criteria query uses the HQLQueryPlan in order to speed things up unfortunately it uses poor keys to do so. That is it resolves various parameters in the query which is used as cache key.
An example: the query select id, name from book where id=? should be used as key for the cache. 
But instead of this it uses: select id, name from book where id=1
So the next time this query is executed with id=2 it will not be found in the QueryPlanCache which results in the creation of a new HQLQueryPlan this is not very efficient I would say.

This problem can be seen when executing the FlushAndTransactionTest#testNoCache method and adding a breakpoint on SessionImpl#list(String query, QueryParameters queryParameters) method. The supplied query is not what I expect select id, name from book where id:= param1 but select id, name from book where id=1, or 2 etc.
This query argument is used for retrieving the HQLQueryPlan from the QueryPlanCache.


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira