[ https://issues.apache.org/jira/browse/KYLIN-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Billy Liu updated KYLIN-3276: ----------------------------- Summary: Fix the query cache bug with dynamic parameter (was: query with dynamic parameter get the same query result) > Fix the query cache bug with dynamic parameter > ---------------------------------------------- > > Key: KYLIN-3276 > URL: https://issues.apache.org/jira/browse/KYLIN-3276 > Project: Kylin > Issue Type: Bug > Components: Driver - JDBC, Query Engine > Affects Versions: v2.2.0 > Environment: Kylin 2.2.0, JDK 1.8 > Reporter: ZHAOXIXIN > Assignee: nichunen > Priority: Major > Fix For: v2.3.1 > > > sql:"select distinct uid from table where daytime=? limit 700000" > ps.setString(1,"2018-01-03") > store the result to ArrayList, and print the size of ArrayList. > when I set the daytime to different dates, the same result I got. > I changed the sql, just change limit value for example > sql:"select distinct uid from table where daytime=? limit 600000" > then I got the right value the same like query from GUI:count (distinct uid) -- This message was sent by Atlassian JIRA (v7.6.3#76005)