Huang Hua created KYLIN-949:
-------------------------------
Summary: Query cache doesn't work properly for prepareStatement
queries
Key: KYLIN-949
URL: https://issues.apache.org/jira/browse/KYLIN-949
Project: Kylin
Issue Type: Bug
Components: REST Service
Affects Versions: v0.7.1, v0.7.2
Reporter: Huang Hua
Assignee: Zhong,Jason
There is a bug in searchQueryInCache() method, for PrepareSqlRequest, the cache
logic is wrong which returns the same result for any PrepareSqlRequest with
same sql no matter what the actual params are.
For example, using "select LEAF_CATEG_ID from KYLIN_SALES where LEAF_CATEG_ID =
? group by LEAF_CATEG_ID;" with params=[65] to fire request, and kylin will
return 65. Let's suppose that query is cached(we can modify kylin settings to
enable it to cache every query).
And then using the same sql but with params=[130], which returns 65 instead of
130.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
