[
https://issues.apache.org/jira/browse/KYLIN-4157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiaoxiang Yu reassigned KYLIN-4157:
-----------------------------------
Assignee: Xiaoxiang Yu
> 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
> Assignee: Xiaoxiang Yu
> 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 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. !image-2019-09-04-15-39-58-276.png!
>
> !image-2019-09-04-15-39-52-867.png!
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
