You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Praveen Kumar (Jira)" <ji...@apache.org> on 2021/07/15 16:06:00 UTC
[jira] [Resolved] (ARROW-13190) [C++] [Gandiva] Change behavior of
INITCAP function
[ https://issues.apache.org/jira/browse/ARROW-13190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Praveen Kumar resolved ARROW-13190.
-----------------------------------
Fix Version/s: 5.0.0
Resolution: Fixed
Issue resolved by pull request 10604
[https://github.com/apache/arrow/pull/10604]
> [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
> Labels: pull-request-available
> Fix For: 5.0.0
>
> Time Spent: 5h 10m
> Remaining Estimate: 0h
>
> 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)