[
https://issues.apache.org/jira/browse/ARROW-13190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anthony Louis Gotlib Ferreira updated ARROW-13190:
--------------------------------------------------
Description:
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])
was:
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])
> [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
> Priority: Trivial
>
> 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)
