[
https://issues.apache.org/jira/browse/DRILL-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16326613#comment-16326613
]
Chun Chang commented on DRILL-5450:
-----------------------------------
0: jdbc:drill:zk=10.10.30.166:5181> select initcap('aaa') from (values(1));
+---------+
| EXPR$0 |
+---------+
| Aaa |
+---------+
1 row selected (0.218 seconds)
0: jdbc:drill:zk=10.10.30.166:5181> select initcap('AAA') from (values(1));
+---------+
| EXPR$0 |
+---------+
| Aaa |
+---------+
1 row selected (0.126 seconds)
0: jdbc:drill:zk=10.10.30.166:5181> select initcap('aAa') from (values(1));
+---------+
| EXPR$0 |
+---------+
| Aaa |
+---------+
1 row selected (0.123 seconds)
0: jdbc:drill:zk=10.10.30.166:5181> select * from sys.version;
+------------------+-------------------------------------------+----------------------------------------+----------------------------+---------------------+----------------------------+
| version | commit_id | commit_message | commit_time | build_email | build_time
|
+------------------+-------------------------------------------+----------------------------------------+----------------------------+---------------------+----------------------------+
| 1.13.0-SNAPSHOT | 52030d1d9cc3b8992a10ade8c7126d66e785043a | Attempt to fix
memory leak in Parquet | 22.12.2017 @ 12:54:09 PST | [email protected] |
22.12.2017 @ 15:22:25 PST |
+------------------+-------------------------------------------+----------------------------------------+----------------------------+---------------------+----------------------------+
1 row selected (0.077 seconds)
> Fix initcap function to convert upper case characters correctly
> ---------------------------------------------------------------
>
> Key: DRILL-5450
> URL: https://issues.apache.org/jira/browse/DRILL-5450
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.10.0
> Reporter: Arina Ielchiieva
> Assignee: Arina Ielchiieva
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.11.0
>
>
> Initcap function converts incorrectly subsequent upper case characters after
> first character.
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
