[ https://issues.apache.org/jira/browse/KYLIN-4157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16922241#comment-16922241 ]
Marc Wu commented on KYLIN-4157: -------------------------------- I already find the root cause and tried to fix them, and it works. Can you assign this bug to me? Thanks. > When using PrepareStatement query, functions within WHERE will cause > InternalErrorException > ------------------------------------------------------------------------------------------- > > Key: KYLIN-4157 > URL: https://issues.apache.org/jira/browse/KYLIN-4157 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v2.6.3 > Reporter: Marc Wu > Priority: Major > Fix For: v2.6.4 > > Attachments: image-2019-09-04-15-39-52-867.png, > image-2019-09-04-15-39-58-276.png > > > Hi Kylin Team: > I found a bug when I'm using PreparedStatement query. > Let me use table KYLIN_SALES to explain the scenario. > There is a SQL like: > select LSTG_FORMAT_NAME, sum(PRICE) from KYLIN_SALES where > lower(LSTG_FORMAT_NAME) = 'fp-gtc' group by LSTG_FORMAT_NAME > In some cases, user doesn't know the LSTG_FORMAT_NAME is upper case or lower > case, or they just want to query data ignoring cases. > So assume they use lower(LSTG_FORMAT_NAME) = 'fp-gtc', it's a function > within the filter. > When I execut !image-2019-09-04-15-39-58-276.png! e this SQL on Kylin web > console, it can get the right result, but when I tried to execute it by > PreparedStatement query on Postman, it threw InternalErrorException. > > !image-2019-09-04-15-39-52-867.png! -- This message was sent by Atlassian Jira (v8.3.2#803003)