[PHOENIX-2766] Calling a function on a CHAR returns the padded

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.6.0
• Labels: char function string

Environment

HDP 2.3.4 with Phoenix 4.4 on Calcite 1.5; also Phoenix 4.6.0 on Calcite 1.3

• Assignee: Unassigned
• Reporter: Kevin Liew
• Created: 14/Mar/16 21:56
• Updated: 14/Mar/16 22:13

Description

select (char_col1) from table

select UPPER(char_col1) from table

select LOWER(char_col1) from table

select COALESCE(char_col1, char_col2) from table

The first returns an unpadded string as expected. The others returns a padded string