Uwe Geercken created DRILL-3490:
-----------------------------------
Summary: 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: Daniel Barclay (Drill)
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)
