Anthony Louis Gotlib Ferreira created ARROW-13190:
-----------------------------------------------------
Summary: [C++] [Gandiva] Change behavior of INITCAP function
Key: ARROW-13190
URL: https://issues.apache.org/jira/browse/ARROW-13190
Project: Apache Arrow
Issue Type: New Feature
Components: C++ - Gandiva
Reporter: Anthony Louis Gotlib Ferreira
Assignee: Anthony Louis Gotlib Ferreira
The current behavior of the `INITCAP` function is to turn the first character
of each word uppercase and remains the other as is.
The desired behavior is to turn the first letter uppercase and the other
lowercase. Any character except the alphanumeric ones should be considered as a
word separator.
That behavior is based on these database systems:
*
[Oracle](https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions065.htm)
* [Postgres]([https://w3resource.com/PostgreSQL/initcap-function.php)]
* [Redshift]([https://docs.aws.amazon.com/redshift/latest/dg/r_INITCAP.html)]
* [Splice
Machine](https://doc.splicemachine.com/sqlref_builtinfcns_initcap.html)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
