[
https://issues.apache.org/jira/browse/PHOENIX-2766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kevin Liew updated PHOENIX-2766:
--------------------------------
Description:
{code:sql}select (char_col1) from table{code}
{code:sql}select UPPER(char_col1) from table{code}
{code:sql}select LOWER(char_col1) from table{code}
{code:sql}select COALESCE(char_col1, char_col2) from table{code}
The first returns an unpadded string as expected. The others returns a padded
string
was:
loc_id is a CHAR column
{code:sql}select (loc_id) from dept{code}
{code:sql}select UPPER(loc_id) from dept{code}
{code:sql}select LOWER(loc_id) from dept{code}
The first returns an unpadded string as expected. The others returns a padded
string
> Calling a function on a CHAR returns the padded
> -----------------------------------------------
>
> Key: PHOENIX-2766
> URL: https://issues.apache.org/jira/browse/PHOENIX-2766
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0
> Environment: HDP 2.3.4 with Phoenix 4.4 on Calcite 1.5; also Phoenix
> 4.6.0 on Calcite 1.3
> Reporter: Kevin Liew
> Priority: Minor
> Labels: char, function, string
>
> {code:sql}select (char_col1) from table{code}
> {code:sql}select UPPER(char_col1) from table{code}
> {code:sql}select LOWER(char_col1) from table{code}
> {code:sql}select COALESCE(char_col1, char_col2) from table{code}
> The first returns an unpadded string as expected. The others returns a padded
> string
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
