[FLINK-24492] incorrect implicit type conversion between numeric and (var)char

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.13.6, 1.14.3, 1.15.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: xuyang
• Reporter: xuyang
• Created: 09/Oct/21 09:47
• Updated: 15/Dec/21 01:44
• Resolved: 31/Oct/21 13:46

Description

The result of the sql "select 1 = '1'" is false. This is caused by the CodeGen. CodeGen  incorrectly transform this "=" to "BinaryStringData.equals (int 1)". And "<>" has the same wrong result.

In my opinion, "=" should have the same behavior with ">" and "<", which have the correct results. So before calcite solves this bug or flink supports this kind of implicit type conversion, we'd better temporarily forbidding this implicit type conversion in "=" and "<>".

Issue Links

• links to: GitHub Pull Request #17444