[DRILL-5450] Fix initcap function to convert upper case characters correctly

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.11.0
• Component/s: Functions - Drill
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Arina Ielchiieva
• Reviewer: Paul Rogers
• Created: 27/Apr/17 11:36
• Updated: 15/Jan/18 23:12
• Resolved: 13/May/17 17:42

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)

Issue Links

• is duplicated by: DRILL-5449 Fix initcap function to convert upper case characters correctly
• links to: GitHub Pull Request #821