[CALCITE-6091] Char that in array or map is truncated if CASE WHEN statement contains null

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jiajun Xie
• Created: 03/Nov/23 12:00
• Updated: 28/Feb/24 06:03

Description

select case when true then array('abc')
            when false then array('d') 
            else null -- Perhaps it will be omitted
end as c 

The sql result type is CHAR(1) ARRAY.

If we use the CHAR(1) ARRAY, array('abc') will be truncated.

> Map has same issue.

 

Issue Links

• relates to: CALCITE-4603 Least restrictive type considers only the last element in collections of collections
• links to: GitHub Pull Request #3501