[FLINK-24413] Casting to a CHAR() and VARCHAR() doesn't trim the string to the specified precision - ASF JIRA

XML

Word

Printable

JSON

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)

causes

FLINK-31653 Using`if` statement for a string subtype of the row type may meet npe in code generated by codegen

is a parent of

FLINK-24753 Enforce CHAR/VARCHAR precision when outputing to a Sink

relates to

FLINK-24586 SQL functions should return STRING instead of VARCHAR(2000)

links to

GitHub Pull Request #17464