[IMPALA-6313] length function returns incorrect value when input is a cast of a string literal

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: Impala 2.9.0, Impala 2.11.0
• Component/s: Backend
• Labels: correctness
• Epic Color: ghx-label-3
• Assignee: Unassigned
• Reporter: N Campbell
• Created: 13/Dec/17 00:28
• Updated: 15/Dec/17 20:02
• Resolved: 13/Dec/17 18:19

Description

The following expressions return a value of 32

select length( concat( cast ( 'a' as char(32) ), '' ) )  from cert.tversion
select length( 'a                               ') from cert.tversion

This expression returns a value of 1 and not 32

select length( cast ( 'a' as char(32) ) ) from cert.tversion

Issue Links

• duplicates: IMPALA-2172 length(CHAR) doesn't consider trailing space