[IMPALA-10753] Incorrect length when multiple CHAR(N) values are inserted

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: Frontend
• Labels: correctness ramp-up
• Epic Color: ghx-label-11
• Assignee: Daniel Becker
• Reporter: Csaba Ringhofer
• Created: 16/Jun/21 14:28
• Updated: 11/Jul/23 16:06
• Resolved: 11/Jul/23 16:06

Description

To reproduce:

CREATE TABLE impala_char_insert (s STRING);

-- all values are CHAR(N) with different N, but all will use the biggest N
INSERT OVERWRITE impala_char_insert VALUES (CAST("1" AS CHAR(1))), (CAST("12" AS CHAR(2))), (CAST("123" AS CHAR(3)));
SELECT length(s) FROM impala_char_insert;
results:
3
3
3

-- inserting the same values in separate INSERTs works correctly
INSERT OVERWRITE impala_char_insert VALUES (CAST("1" AS CHAR(1)));
INSERT INTO impala_char_insert VALUES (CAST("12" AS CHAR(2)));
INSERT INTO impala_char_insert VALUES (CAST("123" AS CHAR(3)));
SELECT length(s) FROM impala_char_insert;
results:
1
2
3

-- if one value is not CHAR(N), then the lengths are correct
INSERT OVERWRITE impala_char_insert VALUES (CAST("1" AS CHAR(1))), (CAST("12" AS VARCHAR(2))), (CAST("123" AS CHAR(3)));
SELECT length(s) FROM impala_char_insert;
results:
1
2
3