Oleg Zinoviev created DRILL-6717:
------------------------------------

             Summary: lower and upper functions not works with national 
charactes
                 Key: DRILL-6717
                 URL: https://issues.apache.org/jira/browse/DRILL-6717
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.14.0, 1.15.0
            Reporter: Oleg Zinoviev
         Attachments: result.csv, sample.json

upper() and lower() functions works only with a ascii characters.

sample dataset:  [^sample.json] 
query:

{code:sql}
select 
  upper(ascii_l) as upper_ascii, 
  upper(national_l) as upper_national, 
  lower(ascii_u) as lower_ascii, 
  lower(national_u) as lower_national 
from dfs.`sample.json`
{code}

drill response:  [^result.csv] 





--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to