[ https://issues.apache.org/jira/browse/FLINK-24413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17426220#comment-17426220 ]
Marios Trivyzas commented on FLINK-24413: ----------------------------------------- I tend to agree with [~jark] at least in the context of DBs as a sink/output. Even with VARCHAR DBs are strict in terms of the maximum length: {{postgres=# *create table t(a varchar(5));*}} {{CREATE TABLE}} {{postgres=# *insert into t(a) values('abcdefg');*}} {{ERROR: value too long for type character varying(5)}} > 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 > > *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)