[ https://issues.apache.org/jira/browse/KYLIN-4260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16984346#comment-16984346 ]
nichunen commented on KYLIN-4260: --------------------------------- I have reproduced the bug, it seems that it's introduced by KYLIN-3434. > When using server side PreparedStatement cache, the query result are not > match on TopN scenario > ----------------------------------------------------------------------------------------------- > > Key: KYLIN-4260 > URL: https://issues.apache.org/jira/browse/KYLIN-4260 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v3.0.0-alpha2, v2.6.4 > Reporter: Marc Wu > Assignee: Marc Wu > Priority: Major > Fix For: v3.0.0, v2.6.5 > > Attachments: image-2019-11-18-15-55-00-312.png, > image-2019-11-18-15-55-11-906.png, image-2019-11-18-19-29-34-489.png, > image-2019-11-18-19-29-42-721.png > > > Hi Kylin team, > I found an issue while server side PreparedStatement enabled. The second time > query and after's result will be different from the first when query TopN, > and the result is not right. > Part of Cube info: > > Dimensions > TRANS_ID > PART_DT > SELLER_ID > BUYER_ID > Measures: > SUM(PRICE) > MAX(PRICE) > TOPN(PRICE) Group By:KYLIN_SALES.SELLER_ID,KYLIN_SALES.BUYER_ID > > SQL: > {code:java} > {"sql":"select seller_id, buyer_id, sum(PRICE) from glaucus.kylin_sales where > PART_DT >= ? and PART_DT <= ? group by seller_id, buyer_id order by > sum(PRICE) desc limit 20","project":"DDTFORTEST_Analytics", > "params":[{"className": "java.lang.String","value": > "2012-01-01"},{"className": "java.lang.String","value": "2012-01-10"}]} > {code} > The First query result: > !image-2019-11-18-15-55-00-312.png! > The Second and after: > !image-2019-11-18-15-55-11-906.png|width=2046,height=1096! > ----------------------------------------------- > h2. Root Cause > Cached preparedContext is changed when doing preparedStatement.executeQuery, > and losing groupByColumns. So the first execution result is correct, the > second and the after will be incorrect. > !image-2019-11-18-19-29-34-489.png! > !image-2019-11-18-19-29-42-721.png! > -- This message was sent by Atlassian Jira (v8.3.4#803005)