You are viewing a plain text version of this content. The canonical link for it is here.

Posted to jira@arrow.apache.org by "Anthony Louis Gotlib Ferreira (Jira)" <ji...@apache.org> on 2021/06/25 21:37:00 UTC

[jira] [Created] (ARROW-13190) [C++] [Gandiva] Change behavior of INITCAP function

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)