[
https://issues.apache.org/jira/browse/FLINK-25187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17459882#comment-17459882
]
Marios Trivyzas commented on FLINK-25187:
-----------------------------------------
[~slinkydeveloper] MySQL:
{noformat}
SELECT CAST(HEX('a2') AS BINARY(10));
=>
{"type":"Buffer","data":[54,49,51,50,0,0,0,0,0,0]}
SELECT CAST(HEX('a2') AS BINARY(3));
=>
{"type":"Buffer","data":[54,49,51]}
SELECT CAST(HEX('a2') AS BINARY(5));
=>
{"type":"Buffer","data":[54,49,51,50,0]}{noformat}
> Apply padding for BINARY(<precision>)
> -------------------------------------
>
> Key: FLINK-25187
> URL: https://issues.apache.org/jira/browse/FLINK-25187
> Project: Flink
> Issue Type: Sub-task
> Reporter: Marios Trivyzas
> Priority: Major
>
> When the resulting byte array that is generated for a *CAST(XXX AS
> BINARY(<precision>)* has *length* < {*}precision{*}, then it should be padded
> with *0* to the right, to end up with a byte array of *precision* length,
> similarly to padding with spaces for {*}CHAR(<precision>){*}.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
