[FLINK-26363] Fail to use such expression like if(1= 1, 2, 3)

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Connectors / Hive
• Assignee: Unassigned
• Reporter: luoyuxia
• Created: 25/Feb/22 03:17
• Updated: 10/Jun/22 03:08
• Resolved: 10/Jun/22 03:08

Description

Using hive dialect, can be reproduced using the following sql

select if(1=1, 2,3)

Then it'll throw such exception " Mismatch of function's argument data type 'BOOLEAN NOT NULL' and actual argument type 'BOOLEAN'.".

The main reason is ScalarOperatorGens always generates expressions will nullable return type, which can be different from the inferred type in Calcite.
We need to fix it in ScalarOperatorGens.

Issue Links

• is duplicated by: FLINK-20765 ScalarOperatorGens doesn't set proper nullability for result type of generated expressions