Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6717

lower and upper functions not works with national charactes

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.14.0
    • 1.15.0
    • None

    Description

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

      sample dataset: sample.json
      query:

      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`
      

      drill response: result.csv

      Attachments

        1. result.csv
          0.1 kB
          Oleg Zinoviev
        2. sample.json
          0.1 kB
          Oleg Zinoviev

        Issue Links

          Activity

            People

              le.louch Oleg Zinoviev
              le.louch Oleg Zinoviev
              Paul Rogers Paul Rogers
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: