Marc Wu created KYLIN-4260: ------------------------------ Summary: 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: v2.6.4, v3.0.0-alpha2 Reporter: Marc Wu Assignee: Marc Wu 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
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 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! -- This message was sent by Atlassian Jira (v8.3.4#803005)