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

lower and upper functions not works with national charactes

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.14.0
    • Fix Version/s: 1.15.0
    • Component/s: None
    • Labels:

      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. sample.json
          0.1 kB
          Oleg Zinoviev
        2. result.csv
          0.1 kB
          Oleg Zinoviev

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: