[jira] [Created] (KYLIN-4157) When using PrepareStatement query, functions within WHERE will cause InternalErrorException

["Marc Wu (Jira)" <ji...@apache.org>]

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)