[
https://issues.apache.org/jira/browse/KYLIN-4157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16922456#comment-16922456
]
ASF GitHub Bot commented on KYLIN-4157:
---------------------------------------
mwu3 commented on pull request #825: KYLIN-4157 When using PrepareStatement
query, functions within WHERE …
URL: https://github.com/apache/kylin/pull/825
…will cause InternalErrorException
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> 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: 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 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)
