[jira] [Commented] (KYLIN-1024) UPPER not support in Kylin

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16947520#comment-16947520 ] 

ASF GitHub Bot commented on KYLIN-1024:
---------------------------------------

luguosheng1314 commented on pull request #873: KYLIN-1024 Upper not support in kylin
URL: https://github.com/apache/kylin/pull/873
 
 
   
 
----------------------------------------------------------------
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:
users@infra.apache.org


> UPPER not support in Kylin
> --------------------------
>
>                 Key: KYLIN-1024
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1024
>             Project: Kylin
>          Issue Type: Sub-task
>          Components: Query Engine
>    Affects Versions: v0.7.1, v0.7.2, v1.0
>            Reporter: Huang Hua
>            Assignee: luguosheng
>            Priority: Minor
>
> UPPER function doesn't work in WHERE clause, "org.apache.kylin.rest.exception.InternalErrorException: UPPER while executing SQL":
> select "MONDRIAN_REGION"."REGION_PROVINCE" as "c0", "MONDRIAN_REGION"."REGION_COUNTRY" as "c1" 
> from "MONDRIAN_REGION" as "MONDRIAN_REGION" 
> where ("MONDRIAN_REGION"."REGION_COUNTRY" = '??') and UPPER("MONDRIAN_REGION"."REGION_PROVINCE") = UPPER('??') 
> group by "MONDRIAN_REGION"."REGION_PROVINCE", "MONDRIAN_REGION"."REGION_COUNTRY" 
> order by CASE WHEN "MONDRIAN_REGION"."REGION_PROVINCE" IS NULL THEN 0 ELSE 1 END, "MONDRIAN_REGION"."REGION_PROVINCE" ASC 
> LIMIT 50000



--
This message was sent by Atlassian Jira
(v8.3.4#803005)