[
https://issues.apache.org/jira/browse/KYLIN-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jiale He updated KYLIN-5393:
----------------------------
Attachment: image-2023-01-10-10-06-13-576.png
> Query SQL statement contains single quotes in the fuzzy match field value and
> fails to parse
> --------------------------------------------------------------------------------------------
>
> Key: KYLIN-5393
> URL: https://issues.apache.org/jira/browse/KYLIN-5393
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 5.0-alpha
> Reporter: Jiale He
> Assignee: Jiale He
> Priority: Major
> Fix For: 5.0-alpha
>
> Attachments: image-2023-01-10-10-04-20-520.png,
> image-2023-01-10-10-06-13-576.png
>
>
> {code:java}
> SELECT
> COUNT(*)
> FROM
> ADVSEARCHIADSECURE_2.vw_exp_commission
> WHERE
> BUSINESS_ID = '15030'
> AND (AMOUNT_UNIT_TYPE_ID = '3449880796')
> AND (AS_OF_PERIOD_ID = '3320923194')
> AND (PERIOD_ID = '3320923194')
> AND (EARNING_GROUP_NAME = 'Events')
> AND (EMPLOYEE_ID = '0053p000007bEzjAAE')
> AND (
> (lower(CUSTOMER_NAME) like '%abb4y000000ggzmcaq%')
> OR (lower(PRODUCT_NAME) like'%abb4y000000ggzmcaq%')
> OR (
> lower(GEOGRAPHY_NAME) like'%abb4y000000ggzmcaq%'
> )
> OR (lower(ORDER_CODE) like'%abb4y000000ggzmcaq%')
> OR (
> lower(ITEM_CODE) like'%abb' 4y000000ggzmcaq % ')
> ) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
