[FLINK-31751] array return type SpecificTypeStrategies.ARRAY and ifThenElse return type is not correct

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.18.0
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: Jacky Lau
• Created: 07/Apr/23 07:34
• Updated: 14/Apr/23 08:28
• Resolved: 14/Apr/23 08:28

Description

like array return type

Type strategy that returns a {@link DataTypes#ARRAY(DataType)} with element type equal to the type of the first argument, which is not equals calcite semantic.

for example

ARRAY<BIGINT NOT NULL> and ARRAY<BIGINT> NOT NULL
it should return  ARRAY<BIGINT> instead of ARRAY<BIGINT NOT NULL>