[
https://issues.apache.org/jira/browse/DRILL-3490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Parth Chandra updated DRILL-3490:
---------------------------------
Assignee: Mehant Baid (was: Daniel Barclay (Drill))
> initcap function creates invalid data on all uppercase data
> -----------------------------------------------------------
>
> Key: DRILL-3490
> URL: https://issues.apache.org/jira/browse/DRILL-3490
> Project: Apache Drill
> Issue Type: Improvement
> Components: Functions - Drill
> Affects Versions: 1.1.0
> Reporter: Uwe Geercken
> Assignee: Mehant Baid
> Priority: Minor
>
> the INITCAP function capitalizes the first character of each word in a given
> string.
> when the given string is already all uppercase, INITCAP produces an invalid
> result.
> Example:
> from the value = HELSINKI-VANTAA AIRPORT
> the INITCAP function returns: H%,3).+)-V!.4!! A)20/24
> a workaround that does work is to first use the LOWER function:
> INITCAP(LOWER(<value>))
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
