[FLINK-31375] the values of map<string,string> are truncated by the CASE WHEN function.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.15.1
• Component/s: Table SQL / API, Table SQL / Runtime
• Assignee: Unassigned
• Reporter: jeff-zou
• Created: 09/Mar/23 06:43
• Updated: 23/Mar/23 06:46

Description

the values of map<string,string> are truncated by the CASE WHEN function.

// sql
create table test (a map<varchar, string>) with ('connector'='print');
insert into test  select * from (values(case when true then map['test','123456789'] else map ['msg_code','0', 'msg_reason', 'abc'] end));

the result:

+I[{test=123}] 

We hope the value of result is '123456789', but I get '123', the length is limited by 'abc'.