[
https://issues.apache.org/jira/browse/IMPALA-10753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Becker reopened IMPALA-10753:
------------------------------------
Closed by mistake.
> Incorrect length when multiple CHAR(N) values are inserted
> ----------------------------------------------------------
>
> Key: IMPALA-10753
> URL: https://issues.apache.org/jira/browse/IMPALA-10753
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Reporter: Csaba Ringhofer
> Assignee: Daniel Becker
> Priority: Minor
> Labels: correctness, ramp-up
>
> To reproduce:
> {code}
> 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
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
