[HIVE-20520] length(CHAR) doesn't consider trailing space

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: 4.0.0-alpha-2
• Component/s: UDF
• Target Version/s: 3.2.0, 4.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Naresh P R
• Created: 07/Sep/18 23:01
• Updated: 27/Feb/24 22:23
• Resolved: 11/Sep/18 21:28

Description

Reproduce steps:

create table test(a char(2), b varchar(2));
insert into test values('L ', 'L ');
select length(a),length(b) from test;
+------+------+
| _c0  | _c1  |
+------+------+
| 1    | 2    |
+------+------+
1 row selected (0.185 seconds)

Here char with trailing spaces are trimmed, whereas leading spaces are not trimmed.

Issue Links

• relates to: ORC-406 ORC: Char(n) and Varchar(n) writers truncate to n bytes & corrupts multi-byte data
• relates to: ORC-412 [C++] ORC: Char(n) and Varchar(n) writers truncate to n bytes & corrupts multi-byte data