Marc Wu created KYLIN-4157: ------------------------------ Summary: 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 Fix For: v2.6.4 Attachments: image-2019-09-04-15-39-52-867.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 execute 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. -- This message was sent by Atlassian Jira (v8.3.2#803003)