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

Fix initcap function to convert upper case characters correctly

    Details

      Description

      Initcap function converts incorrectly subsequent upper case characters after first character.

      0: jdbc:drill:zk=local> select initcap('aaa') from (values(1));
      +---------+
      | EXPR$0  |
      +---------+
      | Aaa     |
      +---------+
      1 row selected (0.275 seconds)
      0: jdbc:drill:zk=local> select initcap('AAA') from (values(1));
      +---------+
      | EXPR$0  |
      +---------+
      | A!!     |
      +---------+
      1 row selected (0.27 seconds)
      0: jdbc:drill:zk=local> select initcap('aAa') from (values(1));
      +---------+
      | EXPR$0  |
      +---------+
      | A!a     |
      +---------+
      1 row selected (0.229 seconds)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                arina Arina Ielchiieva
                Reviewer:
                Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: