[ https://issues.apache.org/jira/browse/FLINK-24413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428221#comment-17428221 ]
jiabao sun commented on FLINK-24413: ------------------------------------ PR is ready https://github.com/apache/flink/pull/17464 > Casting to a CHAR() and VARCHAR() doesn't trim the string to the specified > precision > ------------------------------------------------------------------------------------ > > Key: FLINK-24413 > URL: https://issues.apache.org/jira/browse/FLINK-24413 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API > Reporter: Marios Trivyzas > Priority: Major > Labels: pull-request-available > > *CAST**('abcdfe' AS CHAR(3))* should trim the string to 3 chars but currently > returns the whole string *'abcdfe'*. > > PostgreSQL and Oracle for example behave as such: > postgres=# select '123456afas'::char(4); > bpchar > -------- > 1234 > (1 row) > postgres=# select '123456afas'::varchar(5); > varchar > --------- > 12345 > (1 row) -- This message was sent by Atlassian Jira (v8.3.4#803005)