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)
