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

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

    [ 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)