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

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Marios Trivyzas
• Reporter: Marios Trivyzas
• Created: 30/Sep/21 08:56
• Updated: 29/Mar/23 07:56
• Resolved: 14/Dec/21 13:11

Description

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)

Issue Links

• 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
• links to: GitHub Pull Request #18063