You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Jiale He (Jira)" <ji...@apache.org> on 2023/01/10 02:01:00 UTC
[jira] [Updated] (KYLIN-5393) Query SQL statement contains single quotes in the fuzzy match field value and fails to parse
[ https://issues.apache.org/jira/browse/KYLIN-5393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiale He updated KYLIN-5393:
----------------------------
Description:
{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}
> 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
>
>
> {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)